6 Replies Latest reply on Feb 16, 2016 8:57 AM by Tyler Garrett

    Do not want Running count to be affected by filter

    Deborah Auer



      I am trying to find the percent of records by the status.  When the status is filtered to show only closed, it should divide the count of closed by the entire count of ALL status's for each month.

      When I filter to show closed only, it gives the running count for only the closed.  I need the running count to be for ALL status's



      Running count of all status's /  count of Closed status's.


      I am unable to get the running count to remain at the month level for all status's when the status is filtered.


      In the attachment, the bottom chart should stay the same  when filtered.  So I can ultimately use this in the example calculation (above).


      It is driving me nuts....