Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table with 5 columns. I expression for each column. I want to be able to limit the results(rows) in the table based on criteria from 2 of the columns. For example my table contains a row for each zip code. Column 1 contains the sum of providers in that zip code and column 2 contains the sum of claims for that zip code. I want to be able to limit the table to show only zip codes that have more than 25 providers and more than 100 claims.
Hi @DanRonsman
Try like below in the dimension
Aggr(If(Sum(Providers)>25 and Sum(Claims)>100, ZipCode), ZipCode)