specify dates in pivot table

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
 
B

Bernie Deitrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Excel does not accept text format! 0
Pivot table report invalid 0
Pivot Table Counting Text Issue 0
SUM & OFFSET & PIVOT TABLE?? 0
pivot 0
Pivot table 0
Pivot table Days to Months 0

Top