Sorting the values as per fixed sequence.

[#1]

We have a pivot table report where data is showing as attached, we need to see the data in the attached sequence.

[dsharmaqv]

looks like alphabetical order

properties > sort > select Text A->Z

[neha_shirsath]

Hi Ravindra,

Pivot table doesn't support the attractive sorting.

But Could you please provide your file for more details.

Thanks,

Neha

[ramasaisaksoft]

Hi Ravi,

For a list box we have only specified orders only those are available in Properties-->Sort

I hope you are asking Load order so select that one.(Remove all checks and select only Load order)

we don't have custom order option.

if you feel you got solution for your issue,please close the thread by clicking "Correct Answer"

[#5]

Hi Deepak,

Sorting is done same as your comment.

Thanks,

Ravindra

[#6]

Hi Rama,

Your solution changes the order but not as requested by user.

Thanks,

Ravindra

[avinashelite]

Create a inline table and define your sort order and then go to your pivot table >Sort>expression > and choose your sort order column

e.g

LOAD * inline

[

Description,Description_Sort

Fe,1

So,2

...

...Etc

];

In the sort expression use the Description_Sort and check the ascending order

Hope this helps you

[rahulpawarb]

Hello Ravindra,

If Description field has limited values then use below expression under Sort by Expression:

If(Description='Fe', 1, If(Description='SiO2', 2, If(Description='AI2O3', 3, If(Description='P', 4, If(Description='Mn', 5, If(Description='CaO', 6, If(Description='MgO', 7, If(Description='K2O', 8, If(Description='LOI', 9, If(Description='MOISTURE', 10, If(Description='SIZE:+0.149 MM', 11, 12)))))))))))

Hope this will be helpful.

Regards!

Rahul

[#9]

Hi Rahul,

Your solution changes the order but not as requested by user.

Thanks,

Ravindra

[#10]

Hi Avinash,

Your solution changes the order but not as requested by user.

Thanks,

Ravindra