How to sort Expression value in Pivot Table

[sarfaraz_sheikh]

Dear All,

How i can sort the pivot table expression value wise .........I tried but unable to achive the same ..

Sarfaraz

[Anonymous]

Can you attach the sample file

[nirmalraj_kj]

Can you post the sample

[sarfaraz_sheikh]

Dear All,

Please find the attached QVW . I want to sort the data RCA wise .

Please have the look.

Sarfaraz

[sarfaraz_sheikh]

Dear All,

Kindly suggest any solution for the above post.......it is important.

Sarfaraz

[avinashelite]

Hi

Please find the attachment for the solution:

solu: go to sort tab>select Expression and use =count(DISTINCT {$<DISP_CATEGORY={'*'},SUB_VERTICAL_DESC={'AUTO'} >} SI_NO)

this will do

[krishna20]

Hi,

PFA, Hope this helps

Regards

Krishna

[Anonymous]

In sort tab - Select first dimension  and enable sort by Y-Value Ascending/Descending.

this will sort the first expression value wise

Regards

Neetha