Sort order in a pivot table

[bartvanwetten]

Dear all,

attached I have a pivot table wich I can't get in a the (ascending) sortorder I want.

It should order ascending by column C1 AND Date.

Can someone help me out?

Thanks in advance.

Bart

[vardhancse]

Chart->right click->sort<tab>

[bartvanwetten]

Sasi,

thx for your reply. I got that far but can't get the right expression for the correct sortorder.

[#4]

Hi Bart,

you'll need to move date up the dimension list if you want to sort that way I believe, as C2 and 3 have multiple dates, something like the attached. Unless I am misunderstanding your requirement

hope that helps

Joe