topic Re: Partial sum in Pivot table with AGGR in QlikView https://community.qlik.com/t5/QlikView/Partial-sum-in-Pivot-table-with-AGGR/m-p/600273#M222148 <HTML><HEAD></HEAD><BODY><P>How about using just <EM>sum([Sales]*[exchange rate]) </EM>as expression?</P></BODY></HTML> Mon, 03 Feb 2014 10:48:10 GMT Gysbert_Wassenaar 2014-02-03T10:48:10Z Partial sum in Pivot table with AGGR https://community.qlik.com/t5/QlikView/Partial-sum-in-Pivot-table-with-AGGR/m-p/600272#M222147 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I found a lot of discussions on the community around this problem, but couldnt still figure out my problem.</P><P></P><P>I have a pivot table with sales data for different countries over the years. For the Sales figure, the sales is multiplied by the exchange rate corresponding to the particular market to display the figure in Eur. The problem is with the subtotal, I need a subtotal in EUR.</P><P>I tried various combinations with aggr and Total ...</P><P>Find attached the dummy app.</P><P></P><P>Thanks a lot in advance!</P></BODY></HTML> Mon, 03 Feb 2014 10:36:49 GMT https://community.qlik.com/t5/QlikView/Partial-sum-in-Pivot-table-with-AGGR/m-p/600272#M222147 2014-02-03T10:36:49Z Re: Partial sum in Pivot table with AGGR https://community.qlik.com/t5/QlikView/Partial-sum-in-Pivot-table-with-AGGR/m-p/600273#M222148 <HTML><HEAD></HEAD><BODY><P>How about using just <EM>sum([Sales]*[exchange rate]) </EM>as expression?</P></BODY></HTML> Mon, 03 Feb 2014 10:48:10 GMT https://community.qlik.com/t5/QlikView/Partial-sum-in-Pivot-table-with-AGGR/m-p/600273#M222148 Gysbert_Wassenaar 2014-02-03T10:48:10Z Re: Partial sum in Pivot table with AGGR https://community.qlik.com/t5/QlikView/Partial-sum-in-Pivot-table-with-AGGR/m-p/600274#M222149 <HTML><HEAD></HEAD><BODY><P>What is meant by in EURO?</P><P>What is Sales*[Exchange Rate] ?</P><P>Are Sales in EURO or in Different Currency?</P><P>If they are in different currency then.. you can simply write SUM(Sales * [Exchange Rate])</P></BODY></HTML> Mon, 03 Feb 2014 10:50:33 GMT https://community.qlik.com/t5/QlikView/Partial-sum-in-Pivot-table-with-AGGR/m-p/600274#M222149 MK_QSL 2014-02-03T10:50:33Z Re: Partial sum in Pivot table with AGGR https://community.qlik.com/t5/QlikView/Partial-sum-in-Pivot-table-with-AGGR/m-p/600275#M222150 <HTML><HEAD></HEAD><BODY><P>Sorry forgot to mention, that the sales figures are in the local</P><P>currencies. and the exchange rate is to convert it to Euro.</P><P>So the expression for the sales is qum(sales) * </P><P>But it does not make sense to Sum up the total sales which are in different</P><P>currencies. I want to sum up the Sales values in Euro.</P></BODY></HTML> Mon, 03 Feb 2014 12:52:55 GMT https://community.qlik.com/t5/QlikView/Partial-sum-in-Pivot-table-with-AGGR/m-p/600275#M222150 2014-02-03T12:52:55Z