Manipulate Pivots (VERY URGENT PLEASE)

[Anil666]

Hello All,

I have a pivot with months.. The raw data to this pivot gets refreshed every week. i need to build my pivot in such a way that it takes only the next 6 months of data..

e.g. - In the Month of May i need the pivot to work in such a way that i can see only May - Oct but when June starts the pivot should show from June - Nov

Any help highly appreciated!!!

 

[Juan Pablo González]

I would create a new column in the raw data with an IF formula to compare the date of the record with the current date. And if the difference is less than 6 months, return a TRUE, else return FALSE.

Then you can place this new field as a page field and select only "TRUE".