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.
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.