I have a table which has the revenue of all the clients in my organisation.
But the catch is, there is more than 1 column for revenues in different currency.
| Clients Name | Revenue USD | Revenue EURO | Revenue INR | Revenue AUD |
|---|
| XYZ Ltd | 100 | 121 | 430 | 256 |
I am using inbuilt KPI to show the Revenue ,However in 1 KPI I can only show revenue of 1 currency.So If I want to show revenue in all four currency,I have to use 4 different KPI's. Which is not feasible for me.
Is there a way to have a radio button or a filter, something like this
| Select Currency |
|---|
| USD |
| INR |
| EURO |
| AUD |
So If I click/Select on EURO all my values get changed to EURO.?
Thanks in advance.
