4 values into one

[#1]

Hello

it is possible to make 4 different values into one?

eg on the picture i have 4 Closed values.

IS it possible to make one value called Closed which is a sum of them all??

Expression is atm.

=count({1<DimPotentialCustomers.RelationID=p({1<DimPotentialCustomers.RelationID={'11', '13','14','16','10','12'}>} DimPotentialCustomers.RelationID)>} DimPotentialCustomers.Company)

[Anonymous · Accepted solution]

Replace your chart dimenension with calculated dimensions, like this:

aggr((if(wildmatch(YourDimension, 'Closed*'), 'Closed', YourDimension), YourDimension)

Regards,

Michael

[#3]

Brilliant, just what i needed!! Thank you