3 Replies Latest reply on Jan 9, 2017 1:01 PM by Jim Dehner

    Creating a calculated field based on filtered measures

    Amie Sarnese

      Hello,

      I am trying to create a calculated field and am running into issues. I am trying to figure out what one measure (that is filtered to only see days >30) represents of the whole (i.e. no filter on days).  Is there a way that I can do this? I have referenced a few other articles that said to create the table in two different charts and create the calculation off of that, but it is not working for me.  Any help is much appreciated!!

       

      Example:

                               Work Orders with Days >30                       Total Work Orders

      Company A                         50                                                       100

      Company B                         100                                                      400

       

      (*Currently the above calcs are on two seperate sheets as I cannot figure out how to filter on specific calculations, only on the sheet as a whole)