Showing Dimension in a Particular Order

[#1]

Hi

Within a pivot table I have a dimension called Group, which has the following headings:- Hardware, New Licences, New Support, Other, Renewed Licences, Renewed Support, Services & Software. 

When I create the table it loads these in alphabetical order however I would like to show them in a specific way, i.e. Hardware, Software, New Licences, Services, New Support, Renewed Licences & Renewed Support.

Is it possible to specify a particular order you'd like dimensions to appear?

thanks

Iain

[Anonymous]

Hi,

You can change the order on the dimension tab of the chart properties by using the Promote and Demote buttons.

[sushil353]

if all above mentioned name are in one dimention. then you can sort them using a flag field.

PFA.

hope that helps you

[#4 · Accepted solution]

Hi,

In the sort tab of the pivot table , select the dimension ("group") and write a sort expression like below.

Thanks

=IF(GROUP=Hardware,1,
IF(GROUP=Software,2,
IF(GROUP=New Licences,3,
IF(GROUP=Services,4,
IF(GROUP=New Support,5,
IF(GROUP=Renewed Licences,6,
IF(GROUP=Renewed Support,7)))))))

[#5]

Thank you, presumably I could put this is the document properties within settings and this will sort them in any future tables I create.

regards

Iain

[#6]

Thank you, this was helpful but I'm going to go with umeshjadhav's reply

kind regards

Iain