9 Replies Latest reply: Jun 4, 2012 12:05 PM by swuehl RSS

Max of one field sorted by other fields in the same Bar Chart

Benoit_FR

Hi all !

 

My Data table is looking like this :

 

 

CodeCustomer NameCountryTypeSalespersonValue
1Food ShopUSShopJohn300
2Computer ShopSpainShopPaul700
3John DoeUSPersonJohn200
..................

 

I am trying to build a Bar Shart who shows the max Value of each field :

chart_exemple.png

I tried to find a solution with the script, but it takes more than 10 mins per max and I lost my selection capacity (I need to keep the selections : if I select US, I should see the best salesperson of the US and so on ...).

 

I tried directly in the chart with the function FirstSortedValue but I fear that I will take too much memory.

 

 

 

Has anyone an idea ? A suggestion ? An example ?

Thanks in advance !