One option would be to create a lookup table and join it to the original table so that a row appears for each status. Another option would be to create a calculation similar to the following:
Then, instead of actually filtering the data, right click on all the other members that do not want to be shown and select Hide.
Hope this helps a little bit!
How about using three calculated fields on the Measure Values shelf as in the attached?
Edit: you can make this display 0 instead of a blank space by changing the formulas to something like:
IF [Status]="Cancelled" THEN 1 ELSE 0 END
Message was edited by: Joe Mako
measure values.twbx.zip 4.0 KB
Thanks very much to both of you for your help.
I went with Joe's suggestion as it worked really well, thanks for going to the trouble of creating a workbook to explain the solution.