We are using Quicksight to embed dashboards for our customers. We have customers in different countries with different currencies. We are using row level security, so it’s no problem to make sure revenue values use the correct currency for each customer.
But we would also like every customer to see their revenue data in tables/charts with a €, $ or £ prefix.
I am aware that one workaround for tables is using the currency symbol as a separate text field. However, as we have quite a few monetary values in our reports, my preference is still a prefix for the same field as the value. Is there any way to dynamically add a prefix to a value (e.g. from a parameter)?