How could I apply a FILTER to an OLAP table to show only those records having a COUNT > 1? For example, there are 10 distinct names in the table with only "David" and "Susan" having counts of 50 and 10, respectively. All other names have a

Hey Phil,

Why do you have to bring in an additional table if you are just going to calculate the count of names? You can just add a KPI- "count(table1)" to your OLAP and this will naturally display all names with COUNT > 1.

Do you also want to display columns from another table? PU_COUNT requires the first and second arguments to be different tables with a 1:N relationship. https://docs.celonis.com/en/PU_COUNT

Hi Sathish,

Thanks for answering. I do have the count(table1) in my output. I just want to exclude those rows that have a count = 1. The reason being is I may have 100 rows with counts > 1 but like 10k+ with a count =1. My goal is to limit the scrolling a user has to do since this OLAP table is dedicated to duplicates. I added the PU in there just because I had used that in other instances to accomplish this..but it will not work in this instance. I wish the FILTER would support FILTER COUNT but I can see why it cannot because it is based on aggregation.

I figured it out! I employed the PU_COUNT(Domain_Table(field),field) > 1. This works because I am filtering on the same table data. The Domain_TABLE give me a temporary table.