topic Re: Totals within year in pivot table in QlikView https://community.qlik.com/t5/QlikView/Totals-within-year-in-pivot-table/m-p/1319800#M409119 <HTML><HEAD></HEAD><BODY><P>Sunny,</P><P></P><P>like charm again. Thx!</P><P></P><P>Bart</P></BODY></HTML> Mon, 17 Jul 2017 13:29:03 GMT bartvanwetten 2017-07-17T13:29:03Z Totals within year in pivot table https://community.qlik.com/t5/QlikView/Totals-within-year-in-pivot-table/m-p/1319797#M409116 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>can anybody help me out on this one. The QlikView document is attached.</P><P></P><P>If I select one year the percentage of the total amount is show correctly. Now if I select two years it should show the percentage still 'within' the year and not, as now, the percentage of the total within the selected two years.</P><P></P><P>Thanks in advance!</P></BODY></HTML> Mon, 17 Jul 2017 12:58:21 GMT https://community.qlik.com/t5/QlikView/Totals-within-year-in-pivot-table/m-p/1319797#M409116 bartvanwetten 2017-07-17T12:58:21Z Re: Totals within year in pivot table https://community.qlik.com/t5/QlikView/Totals-within-year-in-pivot-table/m-p/1319798#M409117 <HTML><HEAD></HEAD><BODY><P>What is that you are expecting? Can you give your expected values you want to see in your table?</P></BODY></HTML> Mon, 17 Jul 2017 13:24:24 GMT https://community.qlik.com/t5/QlikView/Totals-within-year-in-pivot-table/m-p/1319798#M409117 vishsaggi 2017-07-17T13:24:24Z Re: Totals within year in pivot table https://community.qlik.com/t5/QlikView/Totals-within-year-in-pivot-table/m-p/1319799#M409118 <HTML><HEAD></HEAD><BODY><P>Try this</P><P><STRONG>=Sum( Aantal_per_eenheid)/&nbsp; sum(total &lt;Periode_Jaar_Only&gt; Aantal_per_eenheid)</STRONG></P></BODY></HTML> Mon, 17 Jul 2017 13:26:30 GMT https://community.qlik.com/t5/QlikView/Totals-within-year-in-pivot-table/m-p/1319799#M409118 sunny_talwar 2017-07-17T13:26:30Z Re: Totals within year in pivot table https://community.qlik.com/t5/QlikView/Totals-within-year-in-pivot-table/m-p/1319800#M409119 <HTML><HEAD></HEAD><BODY><P>Sunny,</P><P></P><P>like charm again. Thx!</P><P></P><P>Bart</P></BODY></HTML> Mon, 17 Jul 2017 13:29:03 GMT https://community.qlik.com/t5/QlikView/Totals-within-year-in-pivot-table/m-p/1319800#M409119 bartvanwetten 2017-07-17T13:29:03Z