Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Item Mix Visualization

so i have 4 columns of binary data 

 

i want to be able to filter through the combinations of the 4 how can i do that?

ie if i have product 1 and product 2 vs having all 4 products?

 

when i try to them into a treemap with their counts in values i just get a total count and selecting each combination does nothing

12 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    Hi Anonymous

     

    Any chance you can post a small example set of data?  That might make it easier to understand what you are after. :)

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

       

      1 meaning they have that item and 0 meaning the dont

      i want to be able to see the different combinations of items customers buy and how it affects my total revenue 

      • Phil_Seamark's avatar
        Phil_Seamark
        Microsoft Employee
        9 years ago

        Hi Anonymous

         

        So for the above example, what is your ideal result?  Can you also mock that up in Excel?