The two values are exchange rates, the first is the current exchange rate at the time of sale. The second is the previous exchange rate for that country.
How do i get this value in a column in this Pivot table by customer?
Current rate - previous rate and calculate it for every rows sale:
To show the increase or decrease in revenue minus the currency conversion difference if any.
Questions Is the revenue increase or decrease due to better or worst conversion rates?
