ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot table page field switch to (all) if my criteria is not avail (https://www.excelbanter.com/excel-discussion-misc-queries/37858-pivot-table-page-field-switch-all-if-my-criteria-not-avail.html)

Angus

Pivot table page field switch to (all) if my criteria is not avail
 
I have 3 criteria at page field of my pivot table: "ture", "false", and
"#N/A". And I hide "true" and "false" so that I can see which data is "#N/A"
at pivot table. Sometimes it works properly as if there is no "#N/A" the
pivot table is blank (i want to hightlight data with "#N/A"), but sometimes
if there is no "#N/A" the page field switch to "(all)", so i see all data at
pivot table but not a blank one. How to make it always shows "#N/A" and blank
at pivot table if there is no "#N/A" data?


All times are GMT +1. The time now is 10:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com