Forum Discussion
page level filters
Hi rmarountas,
From what I know, you can use a calculated column using the formula below, then use it in page level filter.NewColumn=IF(Table[case]<=20,1,0)
Then in page level filter, select [NewColumn]=1, which will affect your report.
Best Regards,
Angelia
Microsoft EmployeeHi rmarountas,
From what I know, you can use a calculated column using the formula below, then use it in page level filter.
NewColumn=IF(Table[case]<=20,1,0)
Then in page level filter, select [NewColumn]=1, which will affect your report.
Best Regards,
Angelia
Hi and thanks for your reply. Unfortunately I am still unable to get it to work. I think the reason that the IF statement you included doesn't solve the issue is that I need to filter on the count of cases and not the value of cases. For example, if I have 7 fatalities in zip code 443XX, filtering out cases with the IF statement you suggest counts each individual case as one, which is less than 20. So the filter excludes all of them because each one of them has a count of less than 20. However, if I have a zip code in the same table with more than 20 cases, the same thing happens. It excludes all the cases because each one is less than 20. I need some way of saying that if a table contains any zip code where the count of cases less than 20, don't display it, and if it contains 20 cases or more, display it on the table.
