https://community.qlik.com/t5/QlikView/Total-saels-by-MonthYear/m-p/1569815#M742234 <P>Sorry, I was doing something wrong.</P><P>the expression works</P><P>Thank You <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 16 Apr 2019 08:30:27 GMT joelle_alhanna 2019-04-16T08:30:27Z https://community.qlik.com/t5/QlikView/Total-saels-by-MonthYear/m-p/1568650#M742230 <P>hello,</P><P>I want to get the total sales by Month Year in one Table as shown below. the month year shows will varies depending on sales calculation (will take 3 previous month from year /month selection). how can I calculate the total sales by monthyear? is it feasible?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><STRONG>Day</STRONG></TD><TD><STRONG>Month and Year</STRONG></TD><TD>Net Sales - Selling Price</TD><TD>Total Sales</TD></TR><TR><TD>1</TD><TD>Feb-2019</TD><TD>10.00</TD><TD>518</TD></TR><TR><TD>1</TD><TD>Mar-2019</TD><TD>12.00</TD><TD>513</TD></TR><TR><TD>4</TD><TD>Feb-2019</TD><TD>15.00</TD><TD>518</TD></TR><TR><TD>4</TD><TD>Mar-2019</TD><TD>11.00</TD><TD>513</TD></TR><TR><TD>5</TD><TD>Feb-2019</TD><TD>25.00</TD><TD>518</TD></TR><TR><TD>5</TD><TD>Mar-2019</TD><TD>288.00</TD><TD>513</TD></TR><TR><TD>6</TD><TD>Feb-2019</TD><TD>200.00</TD><TD>518</TD></TR><TR><TD>6</TD><TD>Mar-2019</TD><TD>200.00</TD><TD>513</TD></TR><TR><TD>7</TD><TD>Jan-2019</TD><TD>250.00</TD><TD>252</TD></TR><TR><TD>7</TD><TD>Feb-2019</TD><TD>268.00</TD><TD>518</TD></TR><TR><TD>7</TD><TD>Mar-2019</TD><TD>2.00</TD><TD>513</TD></TR></TBODY></TABLE> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Total-saels-by-MonthYear/m-p/1568650#M742230 joelle_alhanna 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Total-saels-by-MonthYear/m-p/1568749#M742231 <P>May be try this</P><PRE>Sum(TOTAL &lt;[Month and Year]&gt; Sales)</PRE> Fri, 12 Apr 2019 12:15:45 GMT https://community.qlik.com/t5/QlikView/Total-saels-by-MonthYear/m-p/1568749#M742231 sunny_talwar 2019-04-12T12:15:45Z https://community.qlik.com/t5/QlikView/Total-saels-by-MonthYear/m-p/1568756#M742232 <P>It did not work since it gave me the sum for the 3 monthyear</P> Fri, 12 Apr 2019 12:47:18 GMT https://community.qlik.com/t5/QlikView/Total-saels-by-MonthYear/m-p/1568756#M742232 joelle_alhanna 2019-04-12T12:47:18Z https://community.qlik.com/t5/QlikView/Total-saels-by-MonthYear/m-p/1568761#M742233 <BLOCKQUOTE><HR /><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/30825">@joelle_alhanna</a>&nbsp;wrote:<BR /><P>It did not work since it gave me the sum for the 3 monthyear</P><HR /></BLOCKQUOTE><P>What does that mean? I am not sure I follow<BR /><BR /></P> Fri, 12 Apr 2019 12:52:03 GMT https://community.qlik.com/t5/QlikView/Total-saels-by-MonthYear/m-p/1568761#M742233 sunny_talwar 2019-04-12T12:52:03Z https://community.qlik.com/t5/QlikView/Total-saels-by-MonthYear/m-p/1569815#M742234 <P>Sorry, I was doing something wrong.</P><P>the expression works</P><P>Thank You <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 16 Apr 2019 08:30:27 GMT https://community.qlik.com/t5/QlikView/Total-saels-by-MonthYear/m-p/1569815#M742234 joelle_alhanna 2019-04-16T08:30:27Z