Forum Discussion
Using a Pie Chart as Slicer
Makes sense! So my topic has many things you can imagine, friuts, veggies, breads, etc. So what I was thinking was rather than unpivot one sheet multiple times have a record number and split the sheets up into a fruit sheet, veggie sheet, bread sheet, etc. So rather than.
| Store | Apples | Bananas | Oranges | Lettuce | Cabbage | Peppers | White Bread | Wheat Bread | Breadsticks |
| Kroger | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 |
| Kroger | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 |
| Kroger | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 |
| Walmart | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 |
| Walmart | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 0 |
| Walmart | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 |
| Publix | 1 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 |
| Publix | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 |
Where you would unpivot 3 times (really making the processor work, my data set make the linking take an hour) I did
| ID | Store |
| 1 | Kroger |
| 2 | Kroger |
| 3 | Kroger |
| 4 | Walmart |
| 5 | Walmart |
| 6 | Walmart |
| 7 | Publix |
| 8 | Publix |
| ID | Apples | Bananas | Oranges |
| 1 | 1 | 0 | 0 |
| 2 | 1 | 0 | 1 |
| 3 | 1 | 0 | 1 |
| 4 | 1 | 1 | 0 |
| 5 | 1 | 1 | 1 |
| 6 | 1 | 1 | 0 |
| 7 | 1 | 0 | 1 |
| 8 | 0 | 1 | 0 |
| ID | Lettuce | Cabbage | Peppers |
| 1 | 1 | 0 | 1 |
| 2 | 0 | 0 | 1 |
| 3 | 1 | 0 | 0 |
| 4 | 0 | 1 | 0 |
| 5 | 1 | 1 | 1 |
| 6 | 0 | 0 | 1 |
| 7 | 1 | 0 | 0 |
| 8 | 0 | 0 | 0 |
| ID | White Bread | Wheat Bread | Breadsticks |
| 1 | 1 | 0 | 0 |
| 2 | 1 | 1 | 1 |
| 3 | 0 | 1 | 0 |
| 4 | 0 | 0 | 1 |
| 5 | 0 | 1 | 0 |
| 6 | 1 | 1 | 1 |
| 7 | 1 | 0 | 0 |
| 8 | 1 | 0 | 1 |
So I only unpivot once, but on three different tables.
However when linking based on ID number the graphs do not interact. Do they have to be in one sheet to interact or am I missing something?
Thanks,
Chris
hi, Anonymous
For these tables you need to create a relationship based on ID number like this, keep Cross filter direct is Both
Then the graphs will do interact.
Best Regards,
Lin