S
steveski
I have a PivotTable with a PageField called “End Flag” which can b
either TRUE or FALSE. I use the drop-down to filter on FALSE. Thi
PivotTable is based on a data entry table where there will usually b
entries with “End Flag” = FALSE. However, it is possible that all “En
Flag” values could be TRUE. In this case the PageField filter revert
to TRUE, and must be manually reset to FALSE. This is a problem for m
because I intend to hide the PivotTable and turn the spreadsheet ove
to a user. If all the “End Flag” entries become TRUE, then th
PageField filter will revert to TRUE, then when new “End Flag” entrie
occur which are FALSE, they will not show up in the chart which i
based on this PivotTable.
Is there a way to force the PageField filter to only show FALSE, eve
when no “End Flag” entries are FALSE?
Thanks
either TRUE or FALSE. I use the drop-down to filter on FALSE. Thi
PivotTable is based on a data entry table where there will usually b
entries with “End Flag” = FALSE. However, it is possible that all “En
Flag” values could be TRUE. In this case the PageField filter revert
to TRUE, and must be manually reset to FALSE. This is a problem for m
because I intend to hide the PivotTable and turn the spreadsheet ove
to a user. If all the “End Flag” entries become TRUE, then th
PageField filter will revert to TRUE, then when new “End Flag” entrie
occur which are FALSE, they will not show up in the chart which i
based on this PivotTable.
Is there a way to force the PageField filter to only show FALSE, eve
when no “End Flag” entries are FALSE?
Thanks