change currency symbol

Anonymous — Fri, 26 Jun 2015 17:09:06 GMT

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

Re: change currency symbol

sunny_talwar — Fri, 26 Jun 2015 17:17:13 GMT

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