Mackers (3/14/2013)
A member is one thing - one product or the sum/avg of a set of productsYou need to define your set as a set as below - a set being a collection of members
WITH Set [Set Of Products] AS { Descendants([Product].CurrentMember, [Product].[Product Name]) }SELECT { } ON COLUMNS, { ([Set Of Products])} ON ROWSFROM [Sales and Warehouse]
Make sense?
Mack
Makes perfect sense!!
Thank you very much!
Rob