Thank you very much Pete. For our purposes the calculated measure or OWC also did not provide the functionality so I will follow your suggestion and look into the 3rd...
Thank you for your response. We ended up writing to the log file. The pivot table has 3 customers selected out of approx 20,000. The mdx in the log had "Except......