A report is a set of filters. Each filter narrows your book a little more, such as active clients, with an MAPD plan, in Miami County.
Step 1 — Choose what to filter by
In the Report Builder, click Select... in the empty row under Filter by and pick a field. Fields are grouped: Individual, Address, Provider, Pharmacy, Rx, Policy and CMS Plan Changes.
Step 2 — Choose IS or IS NOT
Under Match, leave IS to include clients who match, or switch to IS NOT to leave them out.
Step 3 — Refine
What you see under Refine depends on the field:
A list of choices — click Select..., check one or more values, then click Add filter. Use the Search box to find a value in a long list.
A date range — pick a From date, a To date, or both, then click Add.
A text box — type part of the value, such as a doctor's last name, and press Enter.
Good to know: Lists such as Source, City, Company, Pharmacy and Rx only show values that are already in your book.
Step 4 — Add more filters and run
Each filter you add gets its own row, and a new empty row appears below it. When you're done, click Run Report.
Heads Up: Changing a filter doesn't update the results by itself. Click Run Report each time you change something.
How filters combine
Different rows all have to match. Status is Active Client and Policy Type is MAPD.
Values in the same row are either/or. County is Miami or Montgomery.
Policy filters have to match on the same policy. Policy Type MAPD plus Company Humana finds clients with a Humana MAPD plan, not clients who have an MAPD plan and a separate Humana plan.
IS NOT on a policy filter leaves out any client who has a matching policy, even if they have other policies too.
Changing or removing a filter
Click the x on a value to remove it, or the arrow at the end of the row to pick more.
Click the trash icon to remove the whole row.
Click Clear to remove every filter and show everyone in your book.
If a row is missing its Refine value, you'll see Please refine your filter selection before running the report. Finish or remove that row.



