Using different Currency options in dashboard

[AH]

I have to make the dashboard which will be filtered based on currency. Consolidate dashboard based on currency.

For example, I have LineAmount and TotalLineAmount which are Transactional Currency----(CurrencyCode in the Table)

I Have LineAmountInFunCurrency and TotalLineAmountInFunCurrency which we get after multiplying the ExchRate(in the table).

I have LineAmountInUSCurrency and Total LineAmountInUSCurrency which will indicate the Global currency view.

My requirement is:

1. Include all currency options in the dashboard based on (Using set analysis) make filters
a)Transactional
b)Functional
c)US Dollar (Global)

2. Add Mutiple tables with different currency.

I would really appreciate your cordial help.

Regards
Shan

Message was edited by: Shan Ahmed

Message was edited by: Shan Ahmed Data file has been added.

[senpradip007]

Your apps is running without data, hence please reload the same and re-upload it again.

[AH]

Hi Pradip,

Can you see the QVW with data now?

The data excel file has also been added for convenience.

Thanks,

Shan