6 Replies Latest reply: Dec 6, 2017 5:33 AM by Poté Amaud GNEKOHI

# Chart on two variables

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

• ###### Re: Chart on two variables

Any luck on this question .... your help is much appreciated.

Thank you.

• ###### Re: Chart on two variables

Hi

Is CHF 300+400. Or 75+400?

• ###### Re: Chart on two variables

DATA:

'Curr1' as TypeCurr ,

Currency1 as Currency,

Sales1 as Sales

etc

and

DATA1:

CONCATENATE (DATA)

'Curr2' as TypeCurr ,

Currency2 as Currency,

Sales2 as Sales

etc

AND THEN use set analysis to exclude USD {<Currency -= {USD} >}

• ###### Re: Chart on two variables

Yes Robert, that should be 75 + 400 for CHF. Thank you for spotting that. Do you have an idea how to draw this chart please ?

• ###### Re: Chart on two variables

Hi,

is it possible to work on data script or not?

• ###### Re: Chart on two variables

Hello ra ta,

It's very difficult to understand your table that you would like.

can you check it or explain better?