Usually I can group them in dimension master item by below expression and use it for pivot table.
Now I want to set up one group (name ‘Scope’) which excludes ‘Unship’ & ‘Unrelease’ without writing other 11 types in expression as below.
The reason I don’t wanna writing other 11 types in expression is these types are dynamic in raw data. Today we have 13 types tomorrow we may have 15 types and 20 in the next week. But one thing I am sure that is ‘Unship’ & ‘Unrelease’ always exists in everyday raw data. That’s why I wanna exclude them in dimension(I don't need to exclude them while importing raw data to QS, no need to change any script fm back end). I try Product = - ‘Unship’ or Product =-‘Unrelease’ but neither one can work
You could kindly check raw data and test apps in the attachment for your reference