W
WhytheQ
I have a pivot table that looks a bit like this
Month
Measure Jul-06 Aug-06 Sep-06
Income 20 30 40
Each month the data table that the pivot is based on has another
month's worth of data added i.e for the above example the income for
Oct-06 will be added.
The problem is that in the above pivot I have manually gone into the
Month field and deselected 'All' and then selected 'Jul-06', 'Aug-06',
'Sep-06', so next month when October is added to the data the above
pivot will be unchanged i.e Oct-06 won't appear: what I want is a pivot
where only the most recent three months in the data field Month appear
in the pivot - is this possible without code??
Rgds
J
Month
Measure Jul-06 Aug-06 Sep-06
Income 20 30 40
Each month the data table that the pivot is based on has another
month's worth of data added i.e for the above example the income for
Oct-06 will be added.
The problem is that in the above pivot I have manually gone into the
Month field and deselected 'All' and then selected 'Jul-06', 'Aug-06',
'Sep-06', so next month when October is added to the data the above
pivot will be unchanged i.e Oct-06 won't appear: what I want is a pivot
where only the most recent three months in the data field Month appear
in the pivot - is this possible without code??
Rgds
J