9 Replies Latest reply: Jun 4, 2012 12:05 PM by Stefan Wühl 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 !