topic Aggregating in App Development

topic Aggregating in App Development https://community.qlik.com/t5/App-Development/Aggregating/m-p/1820499#M67261 <P>Hello Guys,</P><P>I'd like to sum the total by year not considering the dimension, as you can you bellow:</P><TABLE><TBODY><TR><TD>Year</TD><TD>Color</TD><TD>Value</TD><TD>Total by year</TD></TR><TR><TD>2019</TD><TD>Yellow</TD><TD>14</TD><TD>187</TD></TR><TR><TD>2019</TD><TD>Blue</TD><TD>84</TD><TD>187</TD></TR><TR><TD>2019</TD><TD>Pink</TD><TD>52</TD><TD>187</TD></TR><TR><TD>2019</TD><TD>Black</TD><TD>37</TD><TD>187</TD></TR><TR><TD>2020</TD><TD>Yellow</TD><TD>23</TD><TD>123</TD></TR><TR><TD>2020</TD><TD>Blue</TD><TD>42</TD><TD>123</TD></TR><TR><TD>2020</TD><TD>Pink</TD><TD>23</TD><TD>123</TD></TR><TR><TD>2020</TD><TD>Black</TD><TD>35</TD><TD>123</TD></TR><TR><TD>2021</TD><TD>Yellow</TD><TD>77</TD><TD>233</TD></TR><TR><TD>2021</TD><TD>Blue</TD><TD>41</TD><TD>233</TD></TR><TR><TD>2021</TD><TD>Pink</TD><TD>68</TD><TD>233</TD></TR><TR><TD>2021</TD><TD>Black</TD><TD>47</TD><TD>233</TD></TR></TBODY></TABLE><P> </P><P>Could you guys help me? </P><P> </P><P>Sincerly, Luiz</P><P> </P> Tue, 30 Nov 2021 18:17:33 GMT Biscoluiz 2021-11-30T18:17:33Z Aggregating https://community.qlik.com/t5/App-Development/Aggregating/m-p/1820499#M67261 <P>Hello Guys,</P><P>I'd like to sum the total by year not considering the dimension, as you can you bellow:</P><TABLE><TBODY><TR><TD>Year</TD><TD>Color</TD><TD>Value</TD><TD>Total by year</TD></TR><TR><TD>2019</TD><TD>Yellow</TD><TD>14</TD><TD>187</TD></TR><TR><TD>2019</TD><TD>Blue</TD><TD>84</TD><TD>187</TD></TR><TR><TD>2019</TD><TD>Pink</TD><TD>52</TD><TD>187</TD></TR><TR><TD>2019</TD><TD>Black</TD><TD>37</TD><TD>187</TD></TR><TR><TD>2020</TD><TD>Yellow</TD><TD>23</TD><TD>123</TD></TR><TR><TD>2020</TD><TD>Blue</TD><TD>42</TD><TD>123</TD></TR><TR><TD>2020</TD><TD>Pink</TD><TD>23</TD><TD>123</TD></TR><TR><TD>2020</TD><TD>Black</TD><TD>35</TD><TD>123</TD></TR><TR><TD>2021</TD><TD>Yellow</TD><TD>77</TD><TD>233</TD></TR><TR><TD>2021</TD><TD>Blue</TD><TD>41</TD><TD>233</TD></TR><TR><TD>2021</TD><TD>Pink</TD><TD>68</TD><TD>233</TD></TR><TR><TD>2021</TD><TD>Black</TD><TD>47</TD><TD>233</TD></TR></TBODY></TABLE><P> </P><P>Could you guys help me? </P><P> </P><P>Sincerly, Luiz</P><P> </P> Tue, 30 Nov 2021 18:17:33 GMT https://community.qlik.com/t5/App-Development/Aggregating/m-p/1820499#M67261 Biscoluiz 2021-11-30T18:17:33Z Re: Aggregating https://community.qlik.com/t5/App-Development/Aggregating/m-p/1820540#M67264 <LI-CODE lang="markup">Sum(Total <Year> Value)</LI-CODE> Thu, 08 Jul 2021 02:55:18 GMT https://community.qlik.com/t5/App-Development/Aggregating/m-p/1820540#M67264 Don_Stocks_ 2021-07-08T02:55:18Z