I've got absolute values in my pivot table and graph, how to use abs function in excel? I want to know the percentages for every row and put them in my graph. For example: in the first row, there are 96 times "gij/ge", 31 times "uTT", 5 times "uST" and 3 times "jij/je/jou". The total of the row would be 135. That means that "gij/ge" stands for about 70% of the row (96/135). I'm able to calculate the percentages for every column, since i got the grand totals per column (values --> show values as "% of grand total"). If I try "values --> show values as % of row total", I'm not getting the right percentages.
Solved by C. J. in 12 mins