Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this condition :
for a dimension brand:
Count(distinct if ( InvoicedQty>Target and YYYY=vYear ,Shop))
I want to count shops that reach the target for all branches.
Can someone help me ?
I'd suggest trying the If() outside the Count() function. Something like the following:
=If((InvoicedQty>Target) and (YYYY=vYear), Count(distinct Shop), 0)
I hope that is helpful. Best regards,
James
Hi James,
My expression is working but what I would like to have is an additional line with the number shops for which the target is reached for all brands.
I have :
Brands | reach target |
Brand 1 | 10 shops |
Brand 2 | 5 shops |
I Would like to have:
Brands | reach target |
Brand 1 | 10 shops |
Brand 2 | 5 shops |
reach target for brand 1 and 2 | 3 Shops |