So my organization has just activated the Multicurrency feature on one of our Sandbox environment for development and testing purposes.
In one of our reports, there is a Currency field which we then summarize it's sum.
The currency of each Record entry is in EUR but our Users wishes to see the sum of the values in USD or in EUR.
In the Report's 'Show' > 'Currencies Using' it is defaulted to EUR.
Now as is stated in here, the default value is the User's Personal Currency. So if the User's Personal Currency is in USD, then the summary will be in USD otherwise it's EUR.
I've seen this very effect on another report. I've seen the Summary headers change whenever I change my Personal Currency.
However, on another Report that has Currency fields being Summed up, I don't see the same thing happen. The 'Show' -> 'Currencies Using' is set to EUR and no matter how many times I change my Personal Currency, the Summary headers will remain as EUR.
I've been stuck on this problem for a while now and I just cannot understand why this is happening.
Is this a Salesforce limitation? A bug? OR I'm likely missing something?