
1. Re: Apply Different Filters to Different Measures in Worksheet
Brian Nordyke Feb 4, 2016 7:24 AM (in response to Brian Nordyke)2 of 2 people found this helpfulHey all,
So after a bit of thinking, I created a workaround that allows me to accomplish my goal above. Essentially, each of the measures that I created were calculated fields that computed cycle times between points in a process.
Rather than add filters to the sheet (which applies the filter to all measures in the sheet  my problem above), I simply changed the calculated fields to essentially 'filter' within the calculated field and return a 'NULL' value (which will not show) if the measure is an outlier.
This was accomplished with a simple if statement  essentially:
If (Calculation) > (Lower Bound) AND (Calculation) < Upper Bound
Then (Calculation)
Else Null
End
This essentially allowed me to bound each calculation (i.e. filter for outliers) directly within the calculated field and show multiple measures, filtered differently, on one sheet.
Hope this helps others!
(Would still love to hear if there's a better option to solve this problem from others though)