Forum Discussion

Mpmp1's avatar
Mpmp1
New Member
2 hours ago

Dynamic headers for a balance sheet

My company is using a fabric model and I am currently creating a balance sheet report. 
This report will allow users to select the currency they are interested in (e.g system currency which would be GBP, local currency (which would be whatever country is shown)

My balance sheet essentially has the accounts on the left and then the country in the row with the balance   

I need to be able to add the currency associated with each country to the row header  

is that possible  

E.g 

When selecting “local currency” 

instead of it showing as “UAE”, “Belgium” , China

i want it to show 

UAE (AED) , Belgium (euro(the symbol would be ideal), China (RMB)

 

No RepliesBe the first to reply