6 Replies Latest reply: Dec 6, 2017 5:33 AM by Pot?? Amaud Gnekohi RSS

    Chart on two variables

    ra ta

      I am trying to draw a chart based on two sets of two columns. example below shows the currency and sales per currency (first raw: usd sales = 100, eur sales = 25)

       

      Currency1Currency2Sales1Sales2
      USDEUR10025
      JPYUSD20050
      GBPCHF30075
      CHFJPY400100

       

      I am trying to merge all and draw (Sales1 + Sales2) by currency while ignoring all USD sales. ultimately, based on the 4 columns above, i would like to draw this:

       

      CurrencySales1 + Sales2
      EUR25
      JPY200 + 100
      GBP300
      CHF300 + 400

       

      Thanks very much for the help.

      Regards,

      Ra