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


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 :


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 !