Sorting Data largest to smallest

[Pavan.Sada.PS]

Hello Friends,

I want to sort the BCS revenue values in my pivot table from highest to lowest for each items (Opportunity name ) in the Secondary service line. Pls advice me on the steps to follow..

Regards,
Pavan S

 

[Luke M]

You will need to move hte Opp. Name field farther to the left in your PT, or else all it can do is sort the 1 name within the customer name (and you won't see a difference. In the attached, I re-arranged the PT, and added a subtotal so you can see that it's sorted.

 

[Pavan.Sada.PS]

Hello Luke,

Makes sense but...
Please have a look at the attached and I have mentioned my requirement.

Regards,
Pavan S

 

[Luke M]

Move 'Customer Name' to the left of 'Opportunity No', or sort Opportunity No descending by value of Sum of BCS.

 

[Pavan.Sada.PS]

Thanks Luke.. It was killing my entire day as I was missing logic that the related field father should on the left of the PT..