topic Pivot table Conversion Rates in App Development https://community.qlik.com/t5/App-Development/Pivot-table-Conversion-Rates/m-p/1132972#M19894 <HTML><HEAD></HEAD><BODY><P>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.</P><P>How do i get this value in a column in this Pivot table by customer?</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Current rate - previous rate and calculate it for every rows sale:</P><P>To show the increase or decrease in revenue minus the currency conversion difference if any. </P><P>Questions Is the revenue increase&nbsp; or decrease due to better or worst conversion rates?</P></BODY></HTML> Sun, 24 Jul 2016 04:58:27 GMT deerhunter 2016-07-24T04:58:27Z Pivot table Conversion Rates https://community.qlik.com/t5/App-Development/Pivot-table-Conversion-Rates/m-p/1132972#M19894 <HTML><HEAD></HEAD><BODY><P>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.</P><P>How do i get this value in a column in this Pivot table by customer?</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Current rate - previous rate and calculate it for every rows sale:</P><P>To show the increase or decrease in revenue minus the currency conversion difference if any. </P><P>Questions Is the revenue increase&nbsp; or decrease due to better or worst conversion rates?</P></BODY></HTML> Sun, 24 Jul 2016 04:58:27 GMT https://community.qlik.com/t5/App-Development/Pivot-table-Conversion-Rates/m-p/1132972#M19894 deerhunter 2016-07-24T04:58:27Z