Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have a pivot chart with the Monweek as columns (it's weekly columns) from 03/01/2009 - current Date... You can just imagine how long is my pivot chart. Thus, I would like to show only those dimensions and compute qty and Total Values that belongs to the current week and incoming weeks..
For example :
If this week's Monweek is 02/03,my 1st column would be 02/03 then 02/10, 02/17...etc
next week, my 1st column would be 02/10 then 2/17, 02/24,...etc
So its just like filtering the current week and incoming weeks.
Tks.
IF you have a Date Field called DATA in the calendar,
Insert in Pivot a Calculated Dimension like this:
IF( DATA> Today()-14 and DATA<=Today(), Monweek)
Hope this helps