Show or hide rows based on set analysis

[Anonymous]

Hi all,

I would like to show an specific range of data in a table chart. The selection is done by passing values from another field, but the result is not the expected. So I thing something is wrong in the expression in the table. Any ideas?

Please find attached file.

Thanks.

Marc.

[carvalguil · Accepted solution]

Hi Marc,

Try the expression below

=only({1<CanaldeVentaId=p(TecnicoId), InicioContratoEjercicioMes=p([FInicio EjercicioMes]), TipoRelacion={'R'}>} Contrato)

Guilherme

[Anonymous]

Guilherme,

It works fine. Thanks.

I tried now to add more info into the table, for instance TipoRelacion, but I can not avoid nulls.

Any idea with this?

Thank you.

[Anonymous]

Sorry, solved by myself.

Thanks.