sorting pivot table

[kris_vliegen]

Hi all,

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

Regards Kris

[kris_vliegen]

I think I found a solution.

=if(GetSelectedCount(_CalDay) <> 1, Rank(Aggr(Avg(Pump_price),Site_Id_Name,_CalYear,_CalMonth)) , Rank(Aggr(Avg(Pump_price),Site_Id_Name,_CalYear,_CalMonth,_CalDay)) )

Thanks for all your help

Regards,

Kris

[kris_vliegen]

Unfortunately it isn't working.

My first impression was fine.

Can anyone help me with my problem?