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

[Anjt87]

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?

 

[Comfy]

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]

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.

 

[Anjt87]

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?

2013

 

[Comfy]

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