Hi All,
i'm stuck with an issue ,
I need to apply sorting on
Chart --> Pivot table
based on Group Dimension - Ascending Order
Expression 1- Descending Sort - Sum
Expression 2- Descending Sort - %
Scenario1 : when iam selecting a individual LIST of Value(single) in Dimension it works fine , (but we ned to display with all values in the dimesnion)
Scenario2 : when selected with ALL LIST of values(ALL) , the sort order getting changed for expressions
Scenario3: when the pivot table is changed as straight table and the particular dimension removed all the sum (desc), and % (desc), and rank appears correctly
if this works , if possible i need to add Rank in Ascending order (1..N), while expression value is in descending order(sum highest to lowest)
thanks in advance.
it would be helpful , if i get possible workarounds , solutions , in case if someone has faced similar kind