topic Re: How to add a column with yearly total value, ignoring the month dimension in the table in App Development https://community.qlik.com/t5/App-Development/How-to-add-a-column-with-yearly-total-value-ignoring-the-month/m-p/2019657#M84195 <P>Hey Thanks a lot!</P> Fri, 23 Dec 2022 12:25:10 GMT LanBiteam 2022-12-23T12:25:10Z How to add a column with yearly total value, ignoring the month dimension in the table https://community.qlik.com/t5/App-Development/How-to-add-a-column-with-yearly-total-value-ignoring-the-month/m-p/2019076#M84169 <P>Hello,</P> <P>I need to create a table like below:</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="20%">Year</TD> <TD width="20%">Month</TD> <TD width="20%">Customer</TD> <TD width="20%">Sales in the Month</TD> <TD width="20%">Sales in the Year</TD> </TR> <TR> <TD width="20%">2022</TD> <TD width="20%">Jan.</TD> <TD width="20%">A</TD> <TD width="20%">100</TD> <TD width="20%">300</TD> </TR> <TR> <TD>2022</TD> <TD>Feb.</TD> <TD>A</TD> <TD>100</TD> <TD>300</TD> </TR> <TR> <TD>2022</TD> <TD>Mar.</TD> <TD>A</TD> <TD>100</TD> <TD>300</TD> </TR> <TR> <TD>2022</TD> <TD>Jan.</TD> <TD>B</TD> <TD>200</TD> <TD>350</TD> </TR> <TR> <TD width="20%">2022</TD> <TD width="20%">Feb.</TD> <TD width="20%">B</TD> <TD width="20%">150</TD> <TD width="20%">350</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>But I don't know how to create the measure "Sales in the Year" in this table. Because of the column "Month" in front.&nbsp;</P> <P>Is this possible? Please advise.</P> <P>Thanks in advance!</P> <P>Best regards,</P> <P>Lan</P> Wed, 21 Dec 2022 16:33:16 GMT https://community.qlik.com/t5/App-Development/How-to-add-a-column-with-yearly-total-value-ignoring-the-month/m-p/2019076#M84169 LanBiteam 2022-12-21T16:33:16Z Re: How to add a column with yearly total value, ignoring the month dimension in the table https://community.qlik.com/t5/App-Development/How-to-add-a-column-with-yearly-total-value-ignoring-the-month/m-p/2019419#M84185 <P>Aggr(NODISTINCT Sum({&lt;Month&gt;}[Sales in the Month]), Customer)</P> <P>Setting Month in set analysis cancels Month from the selection. the aggr calculates per customer. The nodistinct shows it on each row.</P> Thu, 22 Dec 2022 15:20:37 GMT https://community.qlik.com/t5/App-Development/How-to-add-a-column-with-yearly-total-value-ignoring-the-month/m-p/2019419#M84185 Michiel_QV_Fan 2022-12-22T15:20:37Z Re: How to add a column with yearly total value, ignoring the month dimension in the table https://community.qlik.com/t5/App-Development/How-to-add-a-column-with-yearly-total-value-ignoring-the-month/m-p/2019657#M84195 <P>Hey Thanks a lot!</P> Fri, 23 Dec 2022 12:25:10 GMT https://community.qlik.com/t5/App-Development/How-to-add-a-column-with-yearly-total-value-ignoring-the-month/m-p/2019657#M84195 LanBiteam 2022-12-23T12:25:10Z