0 Replies Latest reply: Jul 24, 2016 12:58 AM by Buck Master RSS

    Pivot table Conversion Rates

    Buck Master

      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?