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 t...
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?

    • Phil_Seamark's avatar
      Phil_Seamark
      Microsoft Employee
      9 years ago

      and are those rows individual transactions or purchases over time?

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        their purchases over time, not transactions

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

       

      i guess something like this where i am able to see the different impacts of item combination on this particular KPI

      • Phil_Seamark's avatar
        Phil_Seamark
        Microsoft Employee
        9 years ago

        If you only have 4 columns as per your example you could just create a new calculated column like this

         

        mix = 'Table1'[Item 1] & "," & 
		 'Table1'[Item 2] & "," &
		 'Table1'[Item 3] & "," & 
		 'Table1'[Item 4]

        and then drag that to a Grid and sum your Revenue column.  I suspect your real example isn't so straight forward??