How do i write a condition in expression in pivot table

[Anonymous]

I would like to write a condition where, I want to write if there is a value in dimension then count/include in that count expression.

[Gysbert_Wassenaar]

count({<MyDimension1={'A'}>} MyDimension1)

Note, if MyDimension1 is a key field that's linking two or more tables then use another non-key field to count:

count({<MyDimension1={'A'}>} MyDimension2_NotAKey)

[javier_florian]

Hi Surender,

Yes, you can create an expression like this:

=Count(Distinct ID)/If(Flag1='Yes',2,1)

Or something more complex like that:

=(Count({<Flag1={"Triple"}, Año={$(vMaxAño)}, Mes={"<=$(=Num(Max(Mes)))"}>} Distinct ID)/3)

+(Count({<Flag1={"Si"}, Año={$(vMaxAño)}, Mes={"<=$(=Num(Max(Mes)))"}>} Distinct ID)/2)

+(Count({<Flag1={"No"}, Año={$(vMaxAño)}, Mes={"<=$(=Num(Max(Mes)))"}>} Distinct ID))

-JFlorian

[Anonymous]

Thank you, it worked.