I have a single metric pivot table with row and column totals enabled. My user wants to see one of the columns divided by row total amount expressed as a percentage of the row total. Is there a way to do this in QS? If so, how?
region, col a, col b, col c, total, c as a % of total
North America, 5, 10, 15, 30, 50%
South America, 4, 46 0, 50, 8%
Pacific,1, 0, 0, 1, 0%
Africa, 0, 0, 19, 19, 100%
Total, 10, 56, 34, 100, 34%
You can try out table calculations on Pivot Table. In case you want to show both “Col C” and “% of total”, try re-adding “col c” to value field well and use that repeated column as a table calculation. Let me know if this works for you.
I don’t know that I have explained myself well, I used ‘col a’, ‘col b’, ‘col c’ to describe the pivot table. I don’t have three columns in my source data. I have one column with three values, ‘a’, ‘b’, and ‘c’. In this case c represents the number of entities that has completed all of the tasks (a is number of entities that have not completed a single task, and b represents the number of entities that has completed some but not all of the tasks). Management wants the raw data, and the % of C of the total.
Adding a pivot table calculation works great if I want to turn the entire pivot to be expressed as percentages.