Hi,
I have a Pivot table chart where users select Start Date and End Date and the Chart shows a trend for those days as shown below:
Dim1 Dim2 31-JAN-16 1-FEB-16 ...................................29-FEB-16
1 a 10 21.................................................80
2 b 11 22..................................................90
3 c 12 23...................................................100
4 d 13 24...................................................105
Start Date = 31-jan-16
End Date = 29-Feb-16
Now the requirement is the Enhance this chart to have another measure which is the difference between two consecutive days:
Eg for 1-Feb-16 , it is 1-Feb-16 - 31-Jan-16 i.e. from above example for row 1 it is 21-10 = 11 and so on for all the days.
Please help to suggest how this can be achieved(keeping the Start Date and End Date dynamic and Chart is Pivot Table )
Thank you !
