How to descend a pivot table after adding a seperate column.

Anjt87

New Member
Joined
Mar 6, 2014
Messages
9
Hi There,
Not sure if it is possilbe, but how to descend a pivot table after adding a seperate column, which containes a funciton based on the the pivot table?
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Comfy

Well-known Member
Joined
Dec 21, 2009
Messages
3,377
I'm not sure what you are asking but you should be able to add a field to your Pivot Table for "Yield"

What version of excel are you using?
 

Anjt87

New Member
Joined
Mar 6, 2014
Messages
9
Hi There,
Not sure if it is possilbe, but how to descend a pivot table after adding a seperate column, which containes a funciton based on the the pivot table?
In this example I have created a Yield column with function based on a function Net Rev/SCC. Now I would like to descend the pivot table based on the Yield column.
 

Comfy

Well-known Member
Joined
Dec 21, 2009
Messages
3,377
Ah you want to sort the results?

You can't sort by the values in a Pivot Table, even if you add the Yield function as a calculated field (to the best of my knowledge).
 

Watch MrExcel Video

Forum statistics

Threads
1,109,551
Messages
5,529,474
Members
409,884
Latest member
Msinmath
Top