Forum Discussion
Subsets with measures
I want to calcualte only sum Shipment Quantity when there was a return. Customer Shipment Quantity Return Quantity Return % A 50 35 70% B 100 5 5% C 340 0 0%...
That is not the same as the measure I suggested. Your example had a column for return quantity. I don't see that column mentioned in your adapted measure. There needs to be a filter on the column to exclude 0 values. Is Return Quantity a measure?
Regards,
Pat
Yes, Return Quantity is a measure as well.