specify dates in pivot table

  • Thread starter Thread starter Dal
  • Start date Start date
D

Dal

Hi,

I have a column in a pivot table but i only want to see dates that are
either today or 7 days before today in the pivot table. Is there any way i
can do this?

thanks
 
Dal,

I would add a column of formulas into the PT source, with a formula like

=(TODAY()-A2)>7

where A2 has a date.

Then use that field as a row or page field, showing only TRUE values.

HTH,
Bernie
MS Excel MVP
 
Back
Top