Summin Pivot Table data from a date selected in the Page field

[Guest]

Hi,

My Pivot Table shows the Count of Values for any one date selected form the
DropDown in the Page Field. What i's like to be able to do is to show a
count of
all records from the date selected to the most recent entry in the table.

EG For Oct 9th 06 their are 23 records. But for the period Oct 09th 06 to
today (Nov 10 06) their are 86 records. The distribution of 86 is what i
would like to show in the Pivot Table.

Thanks

John

 

[Debra Dalgleish]

You could add a field to the source data, to calculate if the record
should be shown in the pivot table. For example, with dates in column A:

=AND(A2>=StartDate,A2<=EndDate)

StartDate and EndDate are named ranges, where the date range could be
manually entered or calculated.

In the pivot table, add the new field to the Page area, and select TRUE
from its dropdown list.