Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Replace your chart dimenension with calculated dimensions, like this:
aggr((if(wildmatch(YourDimension, 'Closed*'), 'Closed', YourDimension), YourDimension)
Regards,
Michael
Replace your chart dimenension with calculated dimensions, like this:
aggr((if(wildmatch(YourDimension, 'Closed*'), 'Closed', YourDimension), YourDimension)
Regards,
Michael
Brilliant, just what i needed!! Thank you