Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Check with this
RangeSum(Only({1} DimF), -sum({<RISK_YEAR = {$(=Max(RISK_YEAR))},RISK_DATE={$(vP17)}>}PREMIUM)/1e10)
Sort this dimension using this expression:
Only({1} Dim)
still no change Same result
Did you sort this calculated dimension (=pick(Dim,DEPT,'TOTAL')) using this -> (Only({1} Dim)) on the sort tab?
Yes Sunny
Change Descending to Ascending.
Also mark the Text checkbox and see if it works.
Regards,
Kaushik Solanki
Then Total comes in between Dept
Uncheck the sorting order for Description and check.
If that also doesnt work then please share the sample data to understand it in detail.
Regards,
Kaushik Solanki
Try this
RangeSum(Only({1} Dim), Rank(DEPT))
and sort ascending
If that doesn't work, try this
RangeSum(Only({1} Dim), -Rank(DEPT))
and sort ascending
I have tried that but still not working. I have attached my sample data pls advise