Thanks in advance.
I have a specific scenario where I'm looking for a solution.
Total records: 1 million
Distinct dates specified below (these dates are generated dynamically on a daily basis and on any day will have 15 distinct dates)
Fields: Date, Measure 1, Measure 2, Measure 3
Date:
05/13/2019
05/10/2019
05/09/2019
05/08/2019
05/07/2019
05/06/2019
04/30/2019
03/31/2019
02/28/2019
01/31/2019
12/31/2019
09/30/2018
06/31/2018
03/31/2018
12/31/2017
Output required:
User should have the ability to select any Date 1 and Date 2 from the dates listed above. For example, user selects Day 1 as 05/06/2019 and Day 2 as 03/31/2018 , the output should be as follows:
Sum of Measure 1 delta, Sum of Measure 2 delta and Sum of Measure 3 delta (for the selected dates 1 & 2)
Percentage difference of Measure 1 delta, Percentage difference of Measure 2 delta, Percentage difference of Measure 3 delta (for the selected dates 1 & 2)
Dual Axis graph to show sum delta and percentage delta.
Also a Multiple list dropdown to choose any specific measure to be displayed.
Thanks,
Ace
Hi Aravind
Please provide a sample workbook.
This will help us help you as we otherwise have to create everything from scratch.
