6 Replies Latest reply: Feb 22, 2017 11:00 AM by Irene Alza

# Hi, I need to obtain the nº of vehicle with max cost.

Hi, I have different vehicles with different cost and I want to obtain the number of vehicle with max cost.

Thanks

• ###### Re: Hi, I need to obtain the nº of vehicle with max cost.

Not sure I understand completely, but may be this:

Count({<Cost = {\$(=Max(Cost))}>} Vechicle)

• ###### Re: Hi, I need to obtain the nº of vehicle with max cost.

Thank you Sunny, but it returns the total nº of vehicles...

For one city (ex Barcelona) I have 25 vehicles (a, b, c, d....) and each vehicle has a cost. I want for Barcelona the letter of vehicle with max cost.

• ###### Re: Hi, I need to obtain the nº of vehicle with max cost.

May be this

Dimension:

City

Expression:

FirstSortedValue(letter, -Cost)

• ###### Re: Hi, I need to obtain the nº of vehicle with max cost.

Thank you, it works!

And now it would be possible to represent as a pot each vehicle in the following chart? now it only shows the vehicle with max cost and I would like to show the different vehicles to see cost distribution in the city:

• ###### Re: Hi, I need to obtain the nº of vehicle with max cost.

Not sure I understand what you are looking for?

And now it would be possible to represent as a pot each vehicle in the following chart? now it only shows the vehicle with max cost and I would like to show the different vehicles to see cost distribution in the city

• ###### Re: Hi, I need to obtain the nº of vehicle with max cost.

I would like to show in X axis the city id, in Y axis maximun cost of the vehicle and in the pots the diferent vehicles (a, b,c) for each city. to see the differences between cities and the cost of the vehicles.

Maybe it is not possible...