sorting difficulties in pivot

[prma7799]

Hi All,

sunindia‌

I am facing some sorting issue with pivot table can anyone please help me.

am using dimension

1- cyclic group(DPTB)

2-

=if(aggr(rank((SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},Quarter=

,[Posting Date]={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear),0,4)}>}[Posting Date])))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}

>}[Gross Sales Amount])

-SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},Quarter=

,[Posting Date]={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear),0,4)}>}[Posting Date])))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}

>}[Sales Return Amount]))/100000),$(=GetCurrentField("DPTB")),Customer)<=$(vTopGRp),Customer,'REST')

3- State

4-month

[#2]

what is the sort order you are trying to achieve?

[sunny_talwar]

I am facing some sorting issue with pivot table can anyone please help me.

What exactly is the issue?

[ganeshreddy]

Hi,

Put you expression in highlighted area for decreasing option.

[prma7799]

Hi Sunny,

in my pivot table am unable to get values in sorting order.

for i put in dimension

1- cyclic group DPTB

2- =if(aggr(rank( sum([Sales] )/100000),$(=GetCurrentField("DPTB")),Customer)<=$(vTopGRp),Customer,'REST')

3- State

4-Month

in  Expression

SUM ([Sales])/100000

in Sorting Tab

I put above expression as descending order

but sorting is not coming properly

see the attached

Thanks

[jonathandienst]

Your picture demonstrates the problem, but provides no information that allows diagnosis and accurate suggestions, so I suggest that you post your qvw or a representative sample.

[ganeshreddy]

Hi qlikview7799,

I am not sure whether i understood your problem right, but try sorting in cyclic group as mentioned below. It may help you to get desired results.

Regards,

Ganesh.