tag:blogger.com,1999:blog-3212620802400885445.post8832007318697687055..comments2008-06-15T16:44:06.952+02:00Doris Edwardshttp://www.blogger.com/profile/14457251493775880724noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-3212620802400885445.post-85833025369188993222008-06-15T16:44:00.000+02:002008-06-15T16:44:00.000+02:00Hi Rikki,<BR/><BR/>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.<BR/><BR/>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.<BR/><BR/>I've linked to your post over at the <A HREF="http://www.justpivottables.com/how-to-use-pivot-tables-to-show-values-and-percentages-side-by-side/" REL="nofollow">Just Pivot Tables Blog</A><BR/><BR/>Thanks<BR/><BR/>Jim<BR/><A HREF="http://www.justpivottables.com" REL="nofollow">www.justpivottables.com</A>Jimhttp://www.blogger.com/profile/11153070456214297566noreply@blogger.com