8 Replies Latest reply: Jan 22, 2016 6:14 AM by ajay singh

# Pivot table sorting

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

• ###### Re: Pivot table sorting

Is there a sample that you can share?

• ###### Re: Pivot table sorting

Hi Sunny,

It is huge qvw

• ###### Re: Pivot table sorting

Hi Priya,

Rgds,

tharindu

• ###### Re: Pivot table sorting

Hi,

I wanted to have sort based on Expression and pivot table

• ###### Re: Pivot table sorting

Hi Sunny,

• ###### Re: Pivot table sorting

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.

• ###### Re: Pivot table sorting

Hi Balraj,

It is pivot. I need to sort on expression

• ###### Re: Pivot table sorting

Hi

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

regards

ajay