14 Replies Latest reply on Apr 5, 2018 12:16 AM by Ben McNally

    Use Table Totals & Grand Total as Action Filter

    Grant Horn

      Is there a way to use a table total or grand total as an action filter?

       

      I've attached a workbook for reference.

       

      On the Membership Dashboard I have two sheets, Membership and All Records. The Membership sheet filters the All Records sheet on selection.

       

      If you click on any number besides a total or grand total, the action filter works properly. However, if you click on a total or grand total the action filter will not work.

       

      Thanks,

       

      Grant