Skip to Content
0
Jun 24, 2018 at 04:36 AM

Filter out duplicate values in SAP Lumira 1.31

131 Views

Hi!

I have a dataset with two columns, "ID" and "Category", where one item can be related to multiple categories, so item ID1 occurs twice, with Category1 and Category2.

I wanted to manually filter out the duplicate value, so I created a calculated dimension of {ID}+"-"+{Category} to see the unique value and filter out one of them, but even if I apply the filter, I can still see that row in my dataset, i.e. the filter doesn't work.

Any ideas on why that is? I've done this before with other datasets and never had this problem before.