sorting pivot table

[kris_vliegen]

Hi all,

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

Regards Kris

[Qrishna]

try 'numeric value' descending.

if that doesnt work,try using expression in the sort:  rank([ total ] expression [ , mode [, format ] ]).

[kris_vliegen]

The numeric value doesn't work.

The expression I use to calculate the FuelPrice is =avg(Pump_price)

What should I use in the sort expression?

[settu_periasamy]

Hi,

What about calc_Date_time sort by Ascending in Numeric value.?

if it is not working, try to upload the sample file?

[Qrishna]

could you please attach some data?

[ChiragPradhan]

Try Num(PumpPrice) in expression and sort ascending.

-Chirag

[kris_vliegen]

Then I got this

[ChiragPradhan]

Can you attach the data you are working with?

[kris_vliegen]

I'm going to try to create a small dashboard with the problem.

[kris_vliegen]

Hi All, here is an example of my pivot-tabel.You should select one mintijd.latitude and then he should sort the data.

REgards,

Kris