Can PowerPivot do this? RRS feed

  • Question

  • Hi all,

    I am stuck trying to visualise some data in PowerPivot Chart.

    This is my issue:

    Given this basic dimensional model:

    [Dim Store] --> [Fact Table] <--[Dim Product]

    And supposing that:
    1. The Fact table is 'Factless' as only counts number of sale events by store, product and vendor;
    2. The Fact table has the degenerated dimension vendorID.
    3. Vendors sell products in different stores.

    How to build a PowerPivot chart to show the relation below?

    total (count of) vendorsID that sold the product 'P1' in the store 'S1' who also sold the product 'P2' in the store 'S2'?

    Can PowerPivot show me that?



    • Moved by Mike Kinsman Monday, July 30, 2012 5:56 PM off topic (From:TechNet Website Feedback)
    Saturday, July 28, 2012 9:31 AM

All replies