1 Reply Latest reply on Sep 30, 2012 7:46 PM by Alex Kerin

    Restrict table to items that have a specific number in any column

    John Woolley

      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?