Home Forums Data Warehousing Strategies and Ideas help to design a Cube that shows me all purchases for those who bought a given product RE: help to design a Cube that shows me all purchases for those who bought a given product

  • Thanks Steve, really appreciate you taking the time to answer.

    Won't your suggestion only show the products selected in you filter though?

    Let's say I've got 26 products A through to Z.

    I want to know those customers that bought product B bought what else?

    So in Excel I'm going to have Rows of Customers, Columns of Products.

    I only want Customers who have bought B without losing the other products in the different columns.

    Or do I misunderstand how you're using Excel (I'm thinking Pivot Table)

    Regards

    Giles