change currency symbol

[Anonymous]

Hi Change currency Symbol and money format based on selections made in the currency list box

Currency Amount

USD          100

EUR           200

CAN           300

upon selecting EUR it should show €200 , $100 for USD or $300 for CAN

John

[sunny_talwar · Accepted solution]

Looking for this:

Try the this script:

Table:

LOAD * Inline [

Currency, Amount

USD, 100

EUR, 200

CAD, 300

];

Left Join (Table)

LOAD Currency,

    Symbol

FROM

[CS.xlsx]

(ooxml, embedded labels, table is Sheet1);

And create a chart with Currency as dimension and =Dual(Symbol&Amount, Amount) as Expression.

HTH

Best,

Sunny