topic Sorting on Pivot based on variable in App Development

Sorting on Pivot based on variable

anushree1 — Mon, 04 Nov 2019 07:04:53 GMT

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

Re: Sorting on Pivot based on variable

Anil_Babu_Samineni — Mon, 04 Nov 2019 07:40:04 GMT

Try for 4th button like

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

Re: Sorting on Pivot based on variable

anushree1 — Mon, 04 Nov 2019 07:58:51 GMT

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

Re: Sorting on Pivot based on variable

anushree1 — Mon, 04 Nov 2019 08:01:47 GMT

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)

Re: Sorting on Pivot based on variable

anushree1 — Tue, 05 Nov 2019 05:35:28 GMT

@kaushiknsolanki , @Vegar .

Could you please suggest on this