Calculate Min Expression

[Anonymous]

Hi All,

I have a calculated price per ton in my chart.

i wish to use the minimum price in a different chart and show the price i would have paid if i took the lowest price.

so far i couldn't get the minimum price so i can use it in a gauge chart for instance.

Pack Type	Ton	Price	Price/Ton	Min(Price/Ton)	min price*Ton
M4	40	200	5	5	200
M4	20	200	10	5	100
M4	10	200	20	5	50
M4	40	300	8	5	200
M4	20	100	5	5	100
M4	10	500	50	5	50

thanks for any help

Avner

[marcus_sommer]

Try something like this:

avg(aggr(Price/Ton), [Pack Type]))

Maybe you need further dimensions within your expression.

- Marcus