Say I have the following worksheet table (the measure is an aggregate sum):
Code A B
456 20 30
I'd like to create a calculated field (dimension) that I could use to filter out both the first and third row, in other words, keep only that record where A and B are both positive for the given Code. I've tried IF/ELSE with sum(measure) > 0 in the conditions but apparently, I can't mix measures and aggregates. Thanks for any pointers.