Sort Order

[upaliwije]

Hi Friends

I have following Pivot table in my doc

I want to Total Column come to the bottom of table and Dept 1 & Dept 2 to remain as it is. The sorting order is

sum(PREMIUM) descending

Further I have a calculated dimension as shown below

=pick(Dim,DEPT,'TOTAL')

Pls help me

[sunny_talwar]

Is this not what you want?

or is this not what you are seeing at your end?

[upaliwije]

This is what I want . Highest Value in 2017 to come to the top

[sunny_talwar · Accepted solution]

Check with this

RangeSum(Only({1} DimF),  -sum({<RISK_YEAR = {$(=Max(RISK_YEAR))},RISK_DATE={$(vP17)}>}PREMIUM)/1e10)