View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John John is offline
external usenet poster
 
Posts: 2,069
Default Summin Pivot Table data from a date selected in the Page field

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