sorting pivot table

[kris_vliegen]

Hi all,

How can I sort this? Pumpprice from 15:00 hoours from smaal to large?

Regards Kris

[settu_periasamy]

Not able to open your document. is anyone have the same issue?

[kris_vliegen]

Can you try it now. There was section access in it. Now it should work.

My excuses for this...

Regards,

Kris

[ChiragPradhan]

Still does not work. Access denied.

[kris_vliegen]

And this one?

[ChiragPradhan]

no

[kris_vliegen]

If this one doen't work I don't now how to delete the sectionaccess.

[settu_periasamy]

Try the attachement..

[kris_vliegen]

No, it isn't working on my pc.

And if it is possible I would like to see the newest date in front.

[ChiragPradhan]

this one is opening..

[ChiragPradhan]

I have tweaked settu_periasamy‌ document slightly and attached here. Sort in pivot is going to be a bit tricky due to multiple dimensions. Since you are using a dimension group here, you have to ensure that the sort orders for each dimension in the group are aligned and you will need to drill down into each dimension for the sort to work.

HTH

Chirag