how to sort in pivot tables on groups and subgroups

[vikasmahajan]

Dear All,

How to sort in pivot tables on groups and subgroups on numeric values as well as on a-z  alphabetic order.

Thanks

Vikas Mahajan

[Anonymous]

Hi

Using the sort expression you can sort your pivot table.

In the sort expression you can specify your sort order like numeric , text.

If you want to sort some specific manner means you can create the sort order variable for that particular field.

like Country  SortOrder

A           1

B           2

C           3

You can mention this order in inline in script

Then you can use this sortOrder in sort exprssion

Regards