• Mackers (3/14/2013)


    A member is one thing - one product or the sum/avg of a set of products

    You 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