1 Reply Latest reply on May 7, 2013 1:21 PM by Mark Holtz

    Use Running Sum in Quick Filter

    Ed Kukec

      Hi All,

       

      I have a table that shows a count of Emergency Department Visits by Facility over time.  The Counts are shown by month, each month represents a column in the table then I have a running sum at the end which displays the total ED Visits for the Time Period Selected for each facility.  The dashboard user has requested the ability to have a filter that allows the user to select only the facilities that have between X and Y Visits per year, essentially a range. So let's say they only want to see Facilities that have between 1000 and 2000 Visits within that time period.  The names of the columns are:

       

      Provider Institution

      Visit Month

      Total ED Visits

       

      How can I grab the running sum for the time period selected and create a quick filter that allows me to do this?

       

      Thanks,

      Ed