Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 3rd 05, 03:58 PM
Gavim Francis
 
Posts: n/a
Default 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   Report Post  
Old February 4th 05, 12:32 AM
Debra Dalgleish
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a Pivot Table Calculated Field to get a Unique Count Mike Struckman Excel Worksheet Functions 1 November 22nd 05 06:32 PM
Removing errors from a Pivot table Mighty Magpie Excel Discussion (Misc queries) 2 February 3rd 05 04:15 PM
Pivot Table Refresh Problems PFL Excel Discussion (Misc queries) 2 January 13th 05 02:24 AM
I am having problems creating pivot table of data wyman Charts and Charting in Excel 1 January 12th 05 06:17 PM
Problem with Pivot Table Drop-Down Menus Mac Excel Worksheet Functions 4 November 7th 04 02:18 PM


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

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017