result line on one dimesion

[#1]

I have a pivot table dimension Brand and an expression with a count to select shops that reach their target for a brand and I would like to have the number of shops that reach all targets.

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

3 shops reach target 1 and 2

[johnw]

Here's one way. See attached.

if(dimensionality()
, count({<"Reaches Target?"={'Y'}>} Shop)
,-sum(aggr(count({<"Reaches Target?"={'Y'}>} Brand)=2,Shop)))