Is there a way to keep the "% of column total" values static when applying filters to the Rows data? i.e. when slicing/filtering only Company ABC, it shows the "% of column total" is 100%. I would like to see the original the % Total (i.e. 6%).
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Pivot Table Filter % of Column total
- Thread starter mschoular
- Start date
