override Group Sort Order

[ali_hijazi]

!Hello

got a pivot table in which I want to sort first by first dimension and first expression

i.e.

the first dimension is Rank I want to sort table by Text thus CAPT, CAPT/Dir etc....

then for each Rank I want to sort the Seniority expression

Please check attached sample

n.b. the override Group Sort Order is always disabled why

[jzimolong]

I don't see the attached sample, please post.

[ali_hijazi]

check now