Hi All,
I am using calculated dimension, which is used to show [As of Date] for Monthly Pull or [As of Date] = latest date. Now my requirement is report should Dates based on the expression, but should not be filtered based on date selection.
Now my report is showing based on dates
11/23/2015,10/30/2015, 9/30/2015 and 8/31/2015.
If I select any date other than the above mentioned dates, it is not showing any data. If I select any of the above mentioned dates, it is only showing that dates.
My requirement is, report should not effect based on filtered dates.
Monthly Pull:
10/30/2015, 9/30/2015, 8/31/2015.
Latest Date - 11/23/2015
Calculation Used:
=Aggr(Only({<[Pull Type] = {'M'}> + <[As of Date] = {"$(vmaxDate)"}>} [As of Date]),[As of Date] )
Thanks in advance!
Cheers!