Thread: [Solved] Pivot table problem
View Single Post
 
Old 05-25-2010, 02:05 PM
Kimberly Kimberly is offline Windows 7 Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

Make Quarter be the column field. make the other field be both the Row field and the Data (values to be counted) field.

Right-click on one of the counts and choose Value field Settings.
Go to the Show Values As tab
UIse the drop-down to choose Show value as % of column total
Reply With Quote