Sorting problem

[k_burata]

Hi,

How do I change sorting of dimensions? I would basically to follow the sort order of the Pivot Table Dimensions. So GLE.HOPE should come first since his start date comes first. I know it was correct when I first did it but Plan was relegated to the bottom and I cant manually change the Order.

Regards,

[Anonymous]

Hi Burata,

Kindly remove the first two dimension's sort . so chart will sort based on Start dimension

Thanks

[jonathandienst · Accepted solution]

You can't change the order of the dimensions sorting in a pivot, but you can control how each dimension sorts.

To sort Employee by date, use the expression option for Employee. If the dates are normal numeric date values, then =Start or =(-Start) should be enough.