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

[lorenzoconforti]

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), YourMeasure)

[BrianDH]

I get Invalid Dimension using

=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')

[BrianDH]

maybe i am placing the formula in the wrong place.  Where does the above script need to be located? 

[lorenzoconforti]

You would need to use the code in your measure

If(condition, measure)

[BrianDH]

This is a measure

>>



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')



<<

[lorenzoconforti]

I understand, you want to show measures where your condition is true. Let's say the measure you want to show is sum(B_BH_AMOUNT_ACT) then, in your measure field, you would write: 

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), sum(B_BH_AMOUNT_ACT))

Which means, when the condition is met (i.e. when your original condition evaluates to true), show the data

[BrianDH]

Oh so I would do that for each column, within Show Column if?

[lorenzoconforti]

yes, for each measure. I would recommend to create a variable with your condition (if it's the same across all the measures) and reference that variable instead (it avoid re-writing the code and makes it easier to manage if you need to make any changes)

[BrianDH]

Will this also work for my columns that are dimensions?