Remember Me?

#1
February 3rd 05, 03:58 PM
 Gavim Francis Posts: n/a
Problems with sorting a pivot table

Hi, I've got an annoying problem in sorting my pivot table and just
cannot find the right option to solve it. Here's the layout of my
Pivot Table -

Column A = the client type, this is either 1, 2, 3 or 4
Column B = Client name - a, b, c, d...
Column C = the names of the 2 companies that have sold to the clients
(y and z)
Column D = the amount that 'a' spent with y and the amount they spent
with z.

I'm trying to sort the table in descending order of the 'z' income in
Column D but whenever I try to do this (Field Settings.. Advanced
Descending Column D) it just sorts by Column B on the gross total of
the sales by y and z.

How can I sort Column B on the total of Column D that is made by
company z? Not the total by y and z.

I hope this makes sense, thanks!

#2
February 4th 05, 12:32 AM
 Debra Dalgleish Posts: n/a

Move the Company Name field to the Row area
Select the z column in the pivot table, and sort it.

Gavim Francis wrote:
Hi, I've got an annoying problem in sorting my pivot table and just
cannot find the right option to solve it. Here's the layout of my
Pivot Table -

Column A = the client type, this is either 1, 2, 3 or 4
Column B = Client name - a, b, c, d...
Column C = the names of the 2 companies that have sold to the clients
(y and z)
Column D = the amount that 'a' spent with y and the amount they spent
with z.

I'm trying to sort the table in descending order of the 'z' income in
Column D but whenever I try to do this (Field Settings.. Advanced
Descending Column D) it just sorts by Column B on the gross total of
the sales by y and z.

How can I sort Column B on the total of Column D that is made by
company z? Not the total by y and z.

I hope this makes sense, thanks!

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Mike Struckman Excel Worksheet Functions 1 November 22nd 05 06:32 PM Mighty Magpie Excel Discussion (Misc queries) 2 February 3rd 05 04:15 PM PFL Excel Discussion (Misc queries) 2 January 13th 05 02:24 AM wyman Charts and Charting in Excel 1 January 12th 05 06:17 PM Mac Excel Worksheet Functions 4 November 7th 04 02:18 PM

All times are GMT +1. The time now is 07:02 AM.