Forum Discussion

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

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

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
Microsoft Employee
9 years ago
and are those rows individual transactions or purchases over time?
- Anonymous
  Not applicable
  9 years ago
  their purchases over time, not transactions
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
  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??
  - Anonymous
    Not applicable
    9 years ago
    i have 4 items i need combinations of it sounds like this would be listing out all 24 combinations for separate revenue
    
    i was hoping to be able to use a treemap so you could select the combinations better and accounting for these different combinations would happen behind the scenes automatically like when im selecting different regions for sales data across the states