Hi, I am struggling to make a pivot table give me percentages. I am fairly new to them and just need this graphs to display each number field, i.e. 7, 8 and 9 as percentage of the other 3 factors in the field. I notice there are no row totals in the pivot data table despite adding the grand totals for rows in options. I attached below (hope it works) the excel with 2 spreadsheets one without any % and another with (total of row % on the 4 tags) but it just shows 100% whatever I do. Any help greatly appreciated!
Percentage Problem2.xlsx
Bookmarks