7 Replies Latest reply on Apr 27, 2018 5:27 AM by Zhouyi Zhang

    Calculation using filters

    Piyush Jain

      Hi All,

       

      I was trying to create a view using sample data attached in which the requirement is to display cumulative count of Rec Id based on filter Action Status.

       

      Basically, Action Status is made of 3 values 'Approved', 'Pending' and 'Implemented' out of which 'Approved' and 'Pending' status is equal to 'Open' in Status Id and 'Implemented' is equal to 'Closed' in Status Id. I would like to have the count of (Open - Closed) Rec Id based on filter Action Status.

       

      Looking at the sample data. (When all the values are selected in Action Filter)

      1. Total Counts where Action Status is 'Approved' and 'Pending'  = 33
      2. Total Counts where Action Status is 'Implemented' = 20
      3. 1-2 = 13 which is total count of Open items now as 20 are already closed

       

      1. Now If I select 'Approved' and 'Pending' separately then it is giving me 17 and 16 respectively as it is calculating out of 33 Open counts
      2. Is there any way to calculate the counts out of 13 Open items only which will give me Approved = 6 and Pending = 7

       

      Thanks in advance!

      Piyush