I have three Levels in a Pivot Table
Dimension : Year
Dimension : Month
Dimension : Day
Expression : No of Unique Visits
For the Current Year, I would like to bring in the count of visits for the same month and date for the previous Year to check the variance.
i.e. for 2018, Sep, 1, I would like to see Current Year Value and the same value for Previous Year which is for 2017, Sep 1 in another column.
Refer the Screenshot (transposed pivot table) of how I want the values to appear.
Any thoughts on how this can be implemented.
I tried Set Analysis with "{ 1 {<....." to exclude all dimensions as below:
Sum({1 <QUOTE_YEAR={2017}, QUOTE_MONTH={'Sep'},DAY_OF_DATE={1,2,3,4}>} [Unique Visits] )
My requirement is to just show the Previous Year value and it should vary based on other dimensions.
Unfortunately, it shows zero value.
Would be great if someone can help me out here...
Thanks,
Bino.
