How to Hide Totals on SOME columns in a pivot table
I have a reports that includes a pivot table. It must include the pivot table. In the measures area are four % fields with aggregation rules of Average. In the measures area are also a revenue and expected revenue column. Our users want the report to have totals at the bottom of the revenue and expected revenue columns only. Easy enough to enable the totals. However, the totals only make sense for revenue and expected revenue. Is there a way to hide the total values that appear for the % columns? Research I've done shows you can turn totals on
0