Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - hide if no data
My pivot table layout looks at only some of the fields in an underlying
Access table. I'd like see only the rows that have data in these fields. Ex: I want to see customer, product, current year sales, gross profit. My underlying data also includes prior year spending. I don't want to see a row for a customer that has only prior year spending. That isn't in my layout & I don't want the pivot table junked up with this data. Any suggestions |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date formatting on a Pivot Chart's Data Table | Charts and Charting in Excel | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
Need Formula to display pivot table source data | Excel Worksheet Functions |