Hello, I need some assistance with removing rows that fall below the threshold I choose. I have a straight table with "Provider" as my dimension and 3 expression field - Member Count that counts distinct members, Claim Count that counts distinct claims, and Avg Claims per Member. My formula for the average is
Count (DISTINCT CLAIM_KEY))/ (Count (DISTINCT SRC_MBR_HIPPA_ID))
Because I have thousands of providers, I only want lines where the Avg Claims per Member is >=10. Any help that can be provided is appreciated. Thank you.
