Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Is there a sample that you can share?
Hi Sunny,
It is huge qvw
Hi Priya,
Don't upload the full file. Just about few rows to understand your requirement.
Rgds,
tharindu
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.
Hi Balraj,
It is pivot. I need to sort on expression
Hi,
I have added sample data.
I wanted to have sort based on Expression and pivot table
Hi Sunny,
I have added sample data
Hi
sorting is not possible in pivot table instead of that you can use straight table for sorting
regards
ajay