Thread: [Solved] Using subtotals in Pivot table formulas
View Single Post
 
Old 10-23-2010, 12:29 AM
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
Leave Job name as a row field, but also add Job Name as a data field ('Count of Job Name', actually)
Set it to display as % of Parent Total, with the base of Client Code.
Reply With Quote