Pivot table sorting

[priyarane]

Hi Community,

I wanted to perform sorting based on for ex; Sum(sales) - first expression in my pivot table and other too.

I have 4 calculated dimensions like

1. =if(IRB_WR_Type = 'Wholesale' ,if(isnull(IRB_Category),'CRR Unallocated',IRB_Category)) as Dim1

2. =if(IRB_WR_Type = 'Wholesale',if(IRB_Band = 'CRR_U',' ',IRB_Band)) as Dim2

3. =if(Match(IRB_Band,'CRR_U') > 0,' ',Num((IRB_Lower_Band*100),0.000)&'%') as Dim3

4. =if(Match(IRB_Band,'CRR_U') > 0,' ',Num((IRB_Higher_Band*100),0.000)&'%') as Dim4

How can I achieve this

[sunny_talwar]

Is there a sample that you can share?

[priyarane]

Hi Sunny,

It is huge qvw

[dinuwanbr]

Hi Priya,

Don't upload the full file. Just about few rows to understand your requirement.

Rgds,

tharindu

[Anonymous]

Sorting based on what??

A pivot table is always sorted first after the first dimension, then the second dimension, etc. This is necessary since the rows are grouped first after the first dimension, then the second dimension, etc. If you want to sort after an expression, you should use a straight table instead.

[priyarane]

Hi Balraj,

It is pivot. I need to sort on expression

[priyarane]

Hi,

I have added sample data.

I wanted to have sort based on Expression and pivot table

[priyarane]

Hi Sunny,

I have added sample data

[#9]

Hi

sorting is not possible in pivot table instead of that you can use straight table for sorting

regards

ajay