I have a table and chart that I want to restrict to customers that have exactly $29,000 total transactions in any single month. It is a moving chart of the last 12 months. My IF statement pulls up only those customers with $29,000 in all months. It is IIF([SpendAmt]=29000,true, false). Then I filter the table to be only those customers that are TRUE.
I want to expand to all customers that has $29,000 in any month. How do I do that?
Can you post some example data?