https://community.qlik.com/t5/Reporting-Service-Alerting/Need-Specific-Field/m-p/2004041#M446 <P>Using a calculated dimension as below while suppressing null values.</P> <P>Aggr(Only({$&lt;[Sub Category]={'Body Lotion'}&gt;} [Sub Category]), [Sub Category],[Partner Name],SKU)</P> Mon, 14 Nov 2022 13:20:34 GMT BrunPierre 2022-11-14T13:20:34Z https://community.qlik.com/t5/Reporting-Service-Alerting/Need-Specific-Field/m-p/2003924#M445 <P>Hi Qlikians,</P> <P>I am stuck to apply 1 filter direct in the data, please help me with that.</P> <P>So I need only Body Lotion data in the data set (Sheet).</P> <P>Body lotion is in Sub Category, Please help me with the formulas also sharing the Snip for better understanding.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="KC3_0-1668410238860.png" style="width: 761px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/93571i6E1F350EF2A80903/image-dimensions/761x314?v=v2" width="761" height="314" role="button" title="KC3_0-1668410238860.png" alt="KC3_0-1668410238860.png" /></span></P> <P>Thanks</P> <P>KC</P> <P>&nbsp;</P> Mon, 14 Nov 2022 07:18:45 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/Need-Specific-Field/m-p/2003924#M445 KC3 2022-11-14T07:18:45Z https://community.qlik.com/t5/Reporting-Service-Alerting/Need-Specific-Field/m-p/2004041#M446 <P>Using a calculated dimension as below while suppressing null values.</P> <P>Aggr(Only({$&lt;[Sub Category]={'Body Lotion'}&gt;} [Sub Category]), [Sub Category],[Partner Name],SKU)</P> Mon, 14 Nov 2022 13:20:34 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/Need-Specific-Field/m-p/2004041#M446 BrunPierre 2022-11-14T13:20:34Z