Sorting order

[upaliwije]

Hi Friends

I have following Pivot Table which I am unable to sort in the order I want

I want it to be sorted on the column BCOD  by the  Avg_bud_per_month and the result should be like shown belo

My expression for Avg_bud_per_month is BUDGET_2018/12 But when I apply it to sort order it does not work Pls help

[prma7799]

Put Avg_bud_per_month expression in sort as desc

[pradosh_thakur]

hi put the expression in the sort tab if it doesn't help post the sample document here.

[upaliwije]

I have already done it

[Anil_Babu_Samineni]

Which version you are using? And can you paste expression you worked for

[upaliwije]

Version =11

my expression

Sum({$<NOTE = {'515','516','602','603','604','612','642','702','704','708','711','712','715','513','517','605','610','611','615','616','618','703','719','722'}>}BUDGET)/12

[Anil_Babu_Samineni]

Certain period of version limitations works only for Column level to each not separate. I assume, I will think this if more that 12+ versions will work expression data point level.

=Aggr((Sum({$<NOTE = {'515','516','602','603','604','612','642','702','704','708','711','712','715','513','517','605','610','611','615','616','618','703','719','722'}>}BUDGET)/12),(TERRITORY_DESC,(=(Sum({$<NOTE = {'515','516','602','603','604','612','642','702','704','708','711','712','715','513','517','605','610','611','615','616','618','703','719','722'}>}BUDGET)/12),(NUMERIC,DESCENDING))))

Note - Try to attach application to work rather thinks if available.