Sorting not working

[nikhilgarg]

Hello,

I have a Pivot table with dimensions:

Role, Region, Department, Username and 2 expressions as Quantity and Amount.

I am implementing the Sorting on 2 expressions.

Under Sort tab , for each dimension i checked expression in descending and used :

pick(match(_SortBy, 'Quantities', 'Amounts'),

     Quantity,

    Amount

     )

But Sorting is not working. Where am i wrong?

Thanks

[sunny_talwar]

Don't think I know how to do it. Tried a lot of things, but did not get it to work. May be somebody else might have a better idea.

Best,

Sunny

[#3]

Hi Nikhil,

you have a hierarchy of dimensions set, these will group accordingly in your pivot table, what you are talking about is splitting this table based on the bottom level username field on a row by row basis. Not something you'll be able to do in a pivot table I'm afraid.

You can order on the Y-value to give you an amount order, this will happen within each dimension though.

As Sunny has said, sounds like your after a straight table to be honest.

Joe