Show the latest Dates on Date Dimension

[Anonymous]

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.

[#2]

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