Row Suppression

[#1]

Hi

I have created a straight table with two dimensions and 5 expressions

The dimensions are the customer name and code. The expressions work sales value etc.

My last expressions works out the difference between the exposure and the credit limit.

Some customers have obviously gone over their credit limit and show a negative value in this expression.

I need to exclude any rows that have a positive value in the final expression, basically include any customers that have gone over their credit limit. I know it is easy enough to exclude columns but not so easy with rows.

Any help would be greatly appreciated. Thanks in advance

Dave

[#2]

Leeway  is a calculation between the credit limit and 2 balances to find which customer have gone over their credit limit. Does that make a difference to the solution?

[#3]

Is this what you need? !

[#4]

Leeway  is a calculation between the credit limit and 2 balances to find which customer have gone over their credit limit. Does that make a difference to the solution?

[vinieme12]

1) Check suppress when value is null on the dimensions as well

2) have you got any other expressions or calculated dimensions?

[#6]

I have two dimensions only one is a calculated dimension to exclude certain customers. Both of them have suppress when value is null checked and the suppress zero-vales is also checked.

[vinieme12]

one is a calculated dimension to exclude certain customers

Has the calculated dimension been encapsulated in AGGR()?

Also why don't you add them to SET analysis instead of calculated dimension?

like example;

SUM(  { <   Customer -= {'John*','Mike*','Leo*'}  > } MEASURE)