Get value in a data island

[julruiz123]

Hello,

I was wondering how i can resolve the next situation. When the date it's selected returns for example all the "Ocupacion" and "Facturacion" asociated with the date filter. But i need a chart with the "Facturacion" where "Historia ocupación, Ingreso ocupación" is equal to "Historia factura, Ingreso factura" independent of the date in "Facturacion".

How i can do it?

Thanks

[julruiz123 · Accepted solution]

Hi,

I solved my problem.

Just i added the field _PK_Historia_Paciente in each table () and i used this set analysis expression.

Count({1<_PK_Historia_Paciente_Facturacion = P({$} _PK_Historia_Paciente)>} [Total cargo])