We have a sales team where some reps sell in sterling and some in Euro.
I have a report about to be rolled out to test with some reps in both currencies.
I will use RLS to make sure they only see their data.
One thing I forgot to consider though was currency. I want them to see the exact same report, pulling from the exact same data but to see it in their own currency.
We use a fixed rate of conversion between these currencies internally if that helps. I have some Euro measures in the main dataset which are for example Euro Sales = [total sales] * 1.18
Any help greatly appreciated. Going to test tomorrow with small group so i can run it all sterling for now but would love to get it sorted beforehand if possible.
perhaps I just need to F12 the current report, rename EURO and adjust the measures in all visuals. I can do that, just wondered if there is a better way so that I don’t have two reports to change going forward with updates.