Sorting on Pivot based on variable

[anushree1]

Hi,

I have a requirement wherein the Pivot in use has 2 dimensions and 3 Expressions.

I have a button variable which helps in Sorting the Chart based on Selection So when Button 1 is clicked it sorts the Chart on 1st Expression Sales Descending and Button 2 it sorts Descending on Expression Growth and Button 3 it sorts  Descending on Expression Growth %. So far its working fine ,now I would like to add button 4 which is the default and must sort ascending on Year Dimension which is the Second Dimension in the chart .

But the sort order can either be ascending or descending on any chart.

So can anyone help me with work around for this

[Anil_Babu_Samineni]

Try for 4th button like

Aggr(Sum(Sales), (NUMERIC), ASC)

[anushree1]

It is not working , i am having 2 dimensions and i passed both of them in aggr and tried but it is giving weird sorted results

[anushree1]

also my second dim is like: AGGR(DUAL($(=Period),RowNo(TOTAL)),Div,$(=Period))

So in the sort I have used  AGGR(DUAL($(=Period),RowNo(TOTAL)),Div,$(=Period),ASC)

[anushree1]

@kaushiknsolanki , @Vegar .

Could you please suggest on this