Filtering in Dimension

[ClareChinonye]

i wrote this set expression in my dimension to filter out the following substatus names from my chart, but i keep getting invalid dimension

={<SubStatusName -= {'Booked On', 'End of Day, Run Complete', 'Shift Change', 'Startup Checks'}>},

and this 

=Sum({<SubStatusName -= {'Booked On', 'End of Day', 'Run Complete', 'Shift Change', 'Startup Checks'}>} TimeInMinutes)

for the measure. the measure works for other charts, but the dimension says invalid 

please what could i be doing wrong in the dimension?

[Parthiban · Accepted solution]

Hi,

Try this in your dimension,

if(SubStatusName<>'Booked On' and SubStatusName<>'End of Day' and SubStatusName<>'Run Complete' and SubStatusName<>'Shift Change' and SubStatusName<>'Startup Checks',SubStatusName)

[Anil_Babu_Samineni]

@ClareChinonye For dimension you can do like this

=Aggr(Sum(If(Not Wildmatch(SubStatusName, 'Booked On', 'End of Day', 'Run Complete', 'Shift Change', 'Startup Checks'), TimeInMinutes), SubStatusName)

[ClareChinonye]

This worked, thanks!