Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Your apps is running without data, hence please reload the same and re-upload it again.
Hi Pradip,
Can you see the QVW with data now?
The data excel file has also been added for convenience.
Thanks,
Shan