Need Specific Field

[KC3]

Hi Qlikians,

I am stuck to apply 1 filter direct in the data, please help me with that.

So I need only Body Lotion data in the data set (Sheet).

Body lotion is in Sub Category, Please help me with the formulas also sharing the Snip for better understanding.

Thanks

KC

[BrunPierre]

Using a calculated dimension as below while suppressing null values.

Aggr(Only({$<[Sub Category]={'Body Lotion'}>} [Sub Category]), [Sub Category],[Partner Name],SKU)