dimension with conditions

[#1]

Hello!.

I need aggregate one expression a one dimensional. This does not have to show projects with cant = 0

the column Cant. has the expression:

count({<EstadoVigente = {1}, Estado = {'PROMESADA','BLOQUEADA'}>}SuperficieVivienda)

and the dimensional is:

Proyecto

The table has to show alone two rows:

Proyecto 3 and Proyecto 4

You help me please!

Thanks

[sunny_talwar · Accepted solution]

You can probably use a calculated dimension here and replace Proyecto with

Aggr(If(count({<EstadoVigente = {1}, Estado = {'PROMESADA','BLOQUEADA'}>}SuperficieVivienda) <> 0, Proyecto), Proyecto)

and remember to check 'Suppress When Value Is Null' on the dimensions tab.

Or you can use a if statement to make sure all the other expressions are 0 or null where Cant. is 0.

If([Cant.] <> 0, Expression2)

If([Cant.] <> 0, Expression3)

and so on....

[#3]

Perfect!! thanks you very much