Pivot table sorting not working

[ankitaag]

Hello All,

I am attaching a sample application where I want the user to select any 1 measure from the listbox and the pivot table should get sorted accordingly.

Please help!

morganaaron‌

Thanks and Regards,

Ankita

[Gysbert_Wassenaar]

Looks to me like it works. It first sorts on Region, then sorts the Departments within the region and so on.

[sunny_talwar]

Similar idea. Check out this link: Re: Sorting not working

HTH

Best,

Sunny

[ankitaag]

sunindia,

thats the link from my own team mate.. so its not useful for me..Thanks

[sunny_talwar]

Hahahaha ya I figured that, but I guess the answer still stays the same that the kind of sorting you are looking for might not work with a pivot table. But I will still not pass any judgement and will wait for somebody to may be give you a solution you are looking for

Best,

Sunny

[ankitaag]

Hi,

Yes I totally agree with that but for Canada Region, Department='', Role='Others' should come first as it has the highest value.

[ankitaag]

Hi Sunindia,

Thankyou.

But previously it was working fine and now I have no idea why it is not working.

[sunny_talwar]

Oh okay.

I would love it if you can share the solution once you have it pinned.

Thank you.

[ankitaag]

FYI

utkarshgarg‌

[swuehl]

You sort Role by sum(Amount), and Role '' has the highest value 1033 + 543 + 1222, so it comes first.

Sum(Amount) will not be considering the preceding dimensions.

(Think about how it will  affect sorting when pivoting Role to the top otherwise)