Using subtotals in Pivot table formulas

		Microsoft Office Forums > Microsoft Excel > Excel
Using subtotals in Pivot table formulas

FAQ

Thread Tools

Display Modes

10-23-2010, 12:29 AM

Kimberly

Windows 7

Office 2010 (Version 14.0)

Expert

Join Date: May 2010

Posts: 517

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding a Total row to pivot Table	hannu	Excel	1	09-18-2010 01:15 AM
Pivot Table Refresh	tpcervelo	Excel	0	09-14-2010 06:54 AM
pivot table source data	hannu	Excel	0	07-03-2010 04:54 AM
Pivot table problem	swindon	Excel	5	05-25-2010 02:05 PM
Table formulas	markg2	Word Tables	0	01-15-2010 06:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:53 AM.