Pivot tables / report filter

[tease]

Hi

i have a pivot table report filter that i cannot sort a-z
i've tried sorting the source data and also right clicking on the first value then choosing display a-z - neither work

has anyone got a solution?

its hurting my head, and when i roll it out it'll hurt the users head :-)

Many thanks

Tease

[Cheeky Charlie]

Pivot tables struggle to sort if there is more than one nesting of row or column criteria - a (rubbish) way to do it is to put the "main" criteria in, then sort, then next criteria, sort etc.

I'd love to see a better solution...

[Andy Pope]

Can you post a small example to demonstrate the incorrect or lack of sorting?

[tease]

Hi

i've attached a screen grab of the lack of sorting

Ian

[malnahar]

Hi Tease

Take the report filter , in your example(Promocode) to the row labels, click the arrow and select sort A to Z, then take the (Promocode) back to report filter.

Regards

[tease]

you're a star

worked a treat - i must remeber that

many thanks

tease