Forum Discussion
Pivot tables showing #DIV/0 when I change the value to percentage
I am trying to get percentages in the pivot tables but every time I switch the value, all the values show #DIV/0!
Hello,
To get % of Grand Total, drag and drop a numeric values field into the Values area. Then, right click and select Show Values As % of Grand Total
To get % of Grand Total, drag and drop a numeric values field into the Values area. Then, right click and select Show Values As % of Grand Total