So "Complete", "Pending", and "Return" are attributes or fields (sorry I dont know the correct terminology) within the dimension "Order Status" so I cannot point a calculated field to those filter names.
For example I have an IF statement where I have to specify what the order status is that says:
IF [Order Status] = 'Closed'
THEN ([Order Number]) END
Order Status is your Dimension and Closed, Pending, Open Etc are Dimension Values. So If I use This Data To Count Those Orders where status is Complete
Order Number Status 1 Complete 2 Pending 3 Return 4 Complete 5 Return
Then you get this
If it Helps, Pl mark it Helpful and CORRECT to close Thread
Order Ex.twbx 16.6 KB
Perfect this is what I needed, appreciate the help