2 Replies Latest reply on Jul 28, 2014 5:37 PM by Robert Sinclair

    compare a sub-set of records against to total

    Robert Sinclair

      Is there a way to use a set as a filter for just one measure on a sheet?   In the following table I have two columns listing calculated field measures, listed by unit (each measure is comprised of hundreds of records).  I have a set that I would like to use to filter many records out of the calculation , but for just one column ('filtered totals').   In this image, both columns are the same, but I wish to exclude all the records in "Set xyz" from the filtered total column.  Can this be done and if so, how?  Thanks rs

       

      2014-07-28_18-02-44.png