https://community.qlik.com/t5/App-Development/How-to-calculate-total-for-years-in-pivot-table/m-p/1633048#M47131 <P>Hi Everyone,</P><P>I have to add column Total for 2019 and 2018(like shown in table below), Not sure how this is done in the below scenario -</P><TABLE><TBODY><TR><TD><P>Name</P></TD><TD><P>Calculated Fields</P></TD><TD><P><STRONG>2019 Total</STRONG></P></TD><TD><P><STRONG>2018 Total</STRONG></P></TD><TD><P>MAR-2019</P></TD><TD><P>FEB-2019</P></TD><TD><P>Jan-2019</P></TD><TD><P>Dec-2018</P></TD><TD><P>Nov-2018</P></TD><TD><P>Aug-2018</P></TD><TD><P>Mar-2018</P></TD><TD><P>Jan-2018</P></TD></TR><TR><TD><P>Name1</P></TD><TD><P>Internal</P></TD><TD><P><STRONG>2</STRONG></P></TD><TD><P><STRONG>10</STRONG></P></TD><TD><P>1</P></TD><TD><P>1</P></TD><TD><P>-</P></TD><TD><P>2</P></TD><TD><P>2</P></TD><TD><P>2</P></TD><TD><P>2</P></TD><TD><P>2</P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>External</P></TD><TD><P><STRONG>4</STRONG></P></TD><TD><P><STRONG>8</STRONG></P></TD><TD><P>2</P></TD><TD><P>2</P></TD><TD><P>-</P></TD><TD><P>4</P></TD><TD><P>4</P></TD><TD><P>-</P></TD><TD><P>-</P></TD><TD><P>-</P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>Legal</P></TD><TD><P><STRONG>6</STRONG></P></TD><TD><P><STRONG>15</STRONG></P></TD><TD><P>3</P></TD><TD><P>-</P></TD><TD><P>3</P></TD><TD><P>5</P></TD><TD><P>5</P></TD><TD><P>5</P></TD><TD><P>-</P></TD><TD><P>-</P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>Item</P></TD><TD><P><STRONG>1</STRONG></P></TD><TD><P><STRONG>2</STRONG></P></TD><TD><P>-</P></TD><TD><P>1</P></TD><TD><P>-</P></TD><TD><P>2</P></TD><TD><P>-</P></TD><TD><P>-</P></TD><TD><P>-</P></TD><TD><P>-</P></TD></TR><TR><TD><P>Name2</P></TD><TD><P>Internal</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>External</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>Legal</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>Item</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to create for such scenario with new&nbsp; calculate column, Could someone please advise the best way.</P><P>&nbsp;</P><P>Thanks in Advance!&nbsp;</P> Sat, 16 Nov 2024 19:55:51 GMT LP27 2024-11-16T19:55:51Z https://community.qlik.com/t5/App-Development/How-to-calculate-total-for-years-in-pivot-table/m-p/1633048#M47131 <P>Hi Everyone,</P><P>I have to add column Total for 2019 and 2018(like shown in table below), Not sure how this is done in the below scenario -</P><TABLE><TBODY><TR><TD><P>Name</P></TD><TD><P>Calculated Fields</P></TD><TD><P><STRONG>2019 Total</STRONG></P></TD><TD><P><STRONG>2018 Total</STRONG></P></TD><TD><P>MAR-2019</P></TD><TD><P>FEB-2019</P></TD><TD><P>Jan-2019</P></TD><TD><P>Dec-2018</P></TD><TD><P>Nov-2018</P></TD><TD><P>Aug-2018</P></TD><TD><P>Mar-2018</P></TD><TD><P>Jan-2018</P></TD></TR><TR><TD><P>Name1</P></TD><TD><P>Internal</P></TD><TD><P><STRONG>2</STRONG></P></TD><TD><P><STRONG>10</STRONG></P></TD><TD><P>1</P></TD><TD><P>1</P></TD><TD><P>-</P></TD><TD><P>2</P></TD><TD><P>2</P></TD><TD><P>2</P></TD><TD><P>2</P></TD><TD><P>2</P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>External</P></TD><TD><P><STRONG>4</STRONG></P></TD><TD><P><STRONG>8</STRONG></P></TD><TD><P>2</P></TD><TD><P>2</P></TD><TD><P>-</P></TD><TD><P>4</P></TD><TD><P>4</P></TD><TD><P>-</P></TD><TD><P>-</P></TD><TD><P>-</P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>Legal</P></TD><TD><P><STRONG>6</STRONG></P></TD><TD><P><STRONG>15</STRONG></P></TD><TD><P>3</P></TD><TD><P>-</P></TD><TD><P>3</P></TD><TD><P>5</P></TD><TD><P>5</P></TD><TD><P>5</P></TD><TD><P>-</P></TD><TD><P>-</P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>Item</P></TD><TD><P><STRONG>1</STRONG></P></TD><TD><P><STRONG>2</STRONG></P></TD><TD><P>-</P></TD><TD><P>1</P></TD><TD><P>-</P></TD><TD><P>2</P></TD><TD><P>-</P></TD><TD><P>-</P></TD><TD><P>-</P></TD><TD><P>-</P></TD></TR><TR><TD><P>Name2</P></TD><TD><P>Internal</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>External</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>Legal</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>Item</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to create for such scenario with new&nbsp; calculate column, Could someone please advise the best way.</P><P>&nbsp;</P><P>Thanks in Advance!&nbsp;</P> Sat, 16 Nov 2024 19:55:51 GMT https://community.qlik.com/t5/App-Development/How-to-calculate-total-for-years-in-pivot-table/m-p/1633048#M47131 LP27 2024-11-16T19:55:51Z