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 !