Click on the image to view the video
EXCEL - Pivot Table Reports
Display results in values & percentages, side by side
For more Refreshers, scroll down to the Archives
Display results in values & percentages, side by side
For more Refreshers, scroll down to the Archives
1 comments:
Hi Rikki,
I've seen very few people use the side by side comparison feature in pivot tables. I think its an effective method of showing the relative importance of the individual items. Its just not very intuitive in Excel.
You might want to consider showing how to sort the data by percent. This change essentially creates a pareto analysis which could also be linked to a pivot chart.
I've linked to your post over at the Just Pivot Tables Blog
Thanks
Jim
www.justpivottables.com
Post a Comment