help with sorting in Pivot table

[Anonymous]

Please see the attached QVW and screen shot which will explain my problem. Thanks for your help in advance.

[Anonymous]

Hi Clever,

Once we apply this can we do sorting for each category in dimension1.

[Clever_Anjos]

You can sort by any column (dimension or expression).

If you want to block this, go to Sort Tab, configure your sorting as desired and uncheck "Allow ..."

[Anonymous]

Hi Clever, i am the check box is disabled for me . ... can you please help me with that.

[Clever_Anjos]

This checkbox? Anyway, sending a demo (PFA)

[Anonymous]

Hi Clever,

I am confused. Can you please help me in the attached qvw file.

[Clever_Anjos]

PFA

[Anonymous]

Hi Clever,

I was sick this two days sorry for the late reply but in the attached document the sold below targeted margin and sold above targeted margin are not is descending order. Please let  me know if i am missing anything.

[Clever_Anjos]

Hope you´re better now from your sickness.

You can go to Sort Tab and configure any sort order you want.

It´s just an example.