Filter Table object

[BrianDH]

I have a 10 column table with some dimensions and some measures.   Globally I only want to show the rows where the below calculation is = true  .  The below Calculation is one of my measure columns.

I am looking for examples.

if(SUM(B_BH_AMOUNT_ACT +
B_BH_AMOUNT_PAY +
B_BH_AMOUNT_GLA +
B_BH_AMOUNT_GLL +
B_BH_AMOUNT_GLQ +
B_BH_AMOUNT_GLR +
B_BH_AMOUNT_GLE +
B_BH_AMOUNT_OTHER)
>
Sum(B_BH_AMOUNT_ACC), 'true', 'false')

Thanks

[BrianDH]

see attached - data I am working with

Image is where i need to get too.

I only want to see rows with flag = 1

[BrianDH · Accepted solution]

I got it working!  =Aggr(if($(vSpend)=1,MasterKey),MasterKey)

I need to filter the rows off the master key! 

AutoNumber((B_BUSINESS_UNIT) & '_'& (B_PROJECT_ID)) as MasterKey,

[lorenzoconforti]

well done