• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Table Sort

dmc3415

New Member
Hi all,


I am new to the forum and signed up for the VBA Class recently. I love the atmosphere of Chandoo and have learned a ton.


I have a question regarding a pivot table sort.


The file can be found here.


https://docs.google.com/spreadsheet/ccc?key=0AqMX-vKd3wf5dFFuT1BtYk5YTlpHNC1Ld2FHVlBIcVE&hl=en_US


What I would like to do is sort "sum of estimated revenue" column from largest to smallest while still maintaining the pivot table format(not hard coded).


It seems as though it groups the prospects "MC" as one and lists them second because their sum would be the second largest value although I would like them to be listed as separate prospects with heir own opportunities.


Please let me know if I am not being clear.


I feel as if I have tried all of the different sort options and am just not sure.


Any help with this is very much appreciated.


Thank you all for teaching me so much.
 
Solution

To sort the outer field in descending order by subtotal, follow these steps:

1. Double-click the field button for the outer field in the row area—the Prospect / Opportunity field in this example.

2. In the PivotTable Field dialog box that opens, click the Advanced button.

3. In the PivotTable Field Advanced Options dialog box, under the AutoSort options,

select Ascending / Descending.

4. From the Using field dropdown list, select the field on which you want to base the

sort—Sum of Est. Revenue in this example.

5. Click OK to close the PivotTable Field Advanced Options dialog box, and click OK

to close the PivotTable Field dialog box.
 
Thank you for your help, but it is not working for me .


Perhaps I am not understanding.


I don't thin I want to sort by subtotal. I would like to keep all values desperate and sort as if they were just regular rows, but keep the pivot table properties.


Because I have multiple "MC" prospect listing it is not sorting them.


were you able to do it?
 
I think we are all confused with what you want, dmc3415. Your first post "What I would like to do is sort "sum of estimated revenue" and then you replied "I don't thin I want to sort by subtotal". So what do you want??


if what Basavaraj proposed isn't what you need, I'm just wild guessing here...


1. Remove Prospect? showing only Opportunity?

2. Change Opportunity as primary?

3. move either prospect or opportunity to column labels?

4. move either prospect or opportunity to Report filter?

5. check out my post

http://chandoo.org/forums/topic/something-to-share-on-rankingsorting-figures-in-a-pivot-talbe-not-a-question

6. can you draw on a piece of paper of how the pivot you want to look like? that may help you in articulating what you think you want to see.
 
Back
Top