Can I sort a Pivot table by subtotals?

		Microsoft Office Forums > Microsoft Excel > Excel
Can I sort a Pivot table by subtotals?

FAQ

Thread Tools

Display Modes

12-07-2010, 06:20 PM

BjornS

Windows Vista Can I sort a Pivot table by subtotals?

Office 2003

Competent Performer

Join Date: Jan 2010

Location: Sweden

Posts: 116

Hi,
First create the pivot table using only the row label "Company Name".
Then sort the pivot table and after that insert the row label "Product name".

Kind regards
Bjorn

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
pivot table design 2	dmonroe	Excel	2	11-15-2010 09:15 AM
Using subtotals in Pivot table formulas	ninfanger	Excel	3	10-23-2010 12:29 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:28 AM.