Excel PivotTable add Percentage of Total column - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 3
Francis
Any idea how to show cell values in one column as a percentage of the grand total of another column, when the two columns are actually different data from each other rather than a cloned copy like your example above? If the two columns you have in your example happen to not be the same data, but instead are two different fields. If you want to make each cell in one of the columns reference the grand total cell at the end of a different column, that contains a different data set, to show your % of grand total comparison? Hope I am explaining this ok....
reply
Any idea how to show cell values in one column as a percentage of the grand total of another column, when the two columns are actually different data from each other rather than a cloned copy like your example above? If the two columns you have in your example happen to not be the same data, but instead are two different fields. If you want to make each cell in one of the columns reference the grand total cell at the end of a different column, that contains a different data set, to show your % of grand total comparison? Hope I am explaining this ok....
reply
Christine
What if you have your data split by month in columns and you only want the % of the grand total for the grand total only? When I do the above, it gives a percentage of the column for all columns.
reply
What if you have your data split by month in columns and you only want the % of the grand total for the grand total only? When I do the above, it gives a percentage of the column for all columns.
reply
Nacho
How do get the Percentage of each category ? For example, Percentages 0-100% in just Beverages...or is that not possible.
reply
How do get the Percentage of each category ? For example, Percentages 0-100% in just Beverages...or is that not possible.
reply
Add a review, comment
Other channel videos
