https://community.qlik.com/t5/App-Development/Filtered-Value/m-p/1968641#M79880 <P>Hello,</P> <P>I would like to ask you for a help.</P> <P>I have folowing columns. Turnover, Date, Year, Month.</P> <P>I am trying to create pivot table, where will be Turnover 2021 (First column), Turnover 2022 (Second column) and Evolution % (Third column), but at the moment I am blind.</P> <P>First, I wanted to create measures Turnover 2021, Turnover 2022 by filtering column Turnover by Date, but my formula wasn´t successful.&nbsp;</P> <P>Can anyone try to help me?</P> <P>Many thanks!</P> <P>Jan N&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Hnowotny17_0-1660554465817.png" style="width: 675px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/86706i741F1DDC6C9EB9C2/image-dimensions/675x135?v=v2" width="675" height="135" role="button" title="Hnowotny17_0-1660554465817.png" alt="Hnowotny17_0-1660554465817.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 15 Aug 2022 09:13:39 GMT Hnowotny17 2022-08-15T09:13:39Z https://community.qlik.com/t5/App-Development/Filtered-Value/m-p/1968641#M79880 <P>Hello,</P> <P>I would like to ask you for a help.</P> <P>I have folowing columns. Turnover, Date, Year, Month.</P> <P>I am trying to create pivot table, where will be Turnover 2021 (First column), Turnover 2022 (Second column) and Evolution % (Third column), but at the moment I am blind.</P> <P>First, I wanted to create measures Turnover 2021, Turnover 2022 by filtering column Turnover by Date, but my formula wasn´t successful.&nbsp;</P> <P>Can anyone try to help me?</P> <P>Many thanks!</P> <P>Jan N&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Hnowotny17_0-1660554465817.png" style="width: 675px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/86706i741F1DDC6C9EB9C2/image-dimensions/675x135?v=v2" width="675" height="135" role="button" title="Hnowotny17_0-1660554465817.png" alt="Hnowotny17_0-1660554465817.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 15 Aug 2022 09:13:39 GMT https://community.qlik.com/t5/App-Development/Filtered-Value/m-p/1968641#M79880 Hnowotny17 2022-08-15T09:13:39Z https://community.qlik.com/t5/App-Development/Filtered-Value/m-p/1976757#M80585 <P>HI&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/193832">@Hnowotny17</a>&nbsp;</P> <P>Might be worth sharing what you have tried, as it would appear you would want sopmething like</P> <P>SUM(&lt;{Year={2021}}&gt;[Turrnover EUR])</P> Mon, 05 Sep 2022 06:18:58 GMT https://community.qlik.com/t5/App-Development/Filtered-Value/m-p/1976757#M80585 Mark_Little 2022-09-05T06:18:58Z