How can I sort in the pivot table for the below scenario

[srinivas1921]

Hi Friends,

I have developed a document using Pivot table with fields are field-1 , field-2, field-3 and these values for these fields as per the below image-1.how do we sorting to get result output as per Image-2. (which expression can be write in the sorting option to get image-2 result)

Kindly provide me solution for the above case.

[ecolomer · Accepted solution]

Write in the sorting label this expresion

=only({1} match(field-3, '301','302','303', '305', '308', '101', '105') )

[srinivas1921]

Hi Enrique,

Along with value 'A'  and also there are values 'B' and 'C' under field-1 in previous level using straight table.When I clicked on B and C values then B level pivot table and C level pivot table will be displayed as shown as

image-1(i.e.second level).So I want to know that same sorting expression will be works fine for the Level-B and Level-C pivot tables or not?

if not kindly provide me solution which works in every level,using single sorting expression.

Many thanks in Advance.

[ecolomer]

Yes, this tecnique is possible to apply in all levels

[srinivas1921]

thanks Enrique