Filter on multiple columns

T

tommcbrny

Hello,

I have a status column in a pivot table report that contains one of several
values:
- Signed off
- QA Testing
- Dev Testing
- New
- ...

I currently include all values in my table, but would like to limit the
items with status = "Signed Off" to only those items updated in the last
week. I would like all other status values to remain as is (all items
regardless of status in the report EXCEPT Signed Off, in other words. Signed
Off should be limited by updated date.)

I have a column containing the last updated date as well.

Is it possible to create a filter to show Signed Off values only if the last
update date is within 1 week AND show all other status values regardless of
update date?

Thanks,

Tom
 
D

Don

I hope someone has a better option, but I would create a new column in my
pivot table data to control what to show. Then you can put different
formulas like the one you need below and pull that to the page section and
choose Yes for display?
 
Top