There is a pivot table with multiple Rows, one field in the Value area.
One of the row types is a Percentage, which works fine in the columns, but not as a Grand Total for a Row. How can I hide, or change the format of the text so it is invisible, just for that one type of row's, grand total. In the Pivot Table there are 4 "types" - one of the "types" in the row set is a percentage. It is this "type", that should be hidden from the Grand Total Sum of amount display.
One of the row types is a Percentage, which works fine in the columns, but not as a Grand Total for a Row. How can I hide, or change the format of the text so it is invisible, just for that one type of row's, grand total. In the Pivot Table there are 4 "types" - one of the "types" in the row set is a percentage. It is this "type", that should be hidden from the Grand Total Sum of amount display.