Set Analisys count Products.

[spividori]

Hi.

I need to count the number of products in existence when the SitioCli = SitioDep in a pivot table

I try to use the following formula but it works:

count({$<Exi=-{0}, SitioCli=SitioDep >} NombreProdu)

This is the data model and I use as SitioCli dimension.

Regards.

[#2]

Hi Sandro P,

have you tried the following expression :

count({$<Exi=-{0}, SitioCli={SitioDep} >} NombreProdu)

[kaushiknsolanki]

Try this.

     count({$<Exi=-{0}, SitioCli={"=SitioCli=SitioDep" >} NombreProdu)

Regards,

Kaushik Solanki

[spividori]

Hi.

This works, but I changed the formula, was as follows:

count({$<Exi=-{0}, SitioDep={"=SitioCli=SitioDep"} >} NombreProdu)

But this works only when I select a SitioCli, otherwise it is zero.

Example.

Selected:

Deselected:

and if I add another expression:

It may make it work without having to select a SitioCli?

Regards.