Hi ,
I have one problem kindly help me to sort this out:
I have one data set in which brands and respective their respective search values are there. And I have another dataset in which I have done unpivoting and have one column name as Attributes and other as Values. Based on these Attributes values are present and their respective brand is present.
Now, I need to implement a relation between these two datasets as if in 'Data2', Attributes = A then Values should be > 0 and based on this brands should pick in the table.
Attributes would be in Slicer (A,B,C and D as dropdown). In Table in Rows as "Brand" variable . But when I select "A" in Slicer then in table I should see only sub categories of A same with B, C and D.
| Brand | SI | A | B | C | D |
| B | 0.839881 | 0 | 1 | 0 | 0 |
| Bb | 6.514407 | 0 | 2 | 0 | 0 |
| Bbb | 0.03975 | 0 | 3 | 0 | 0 |
| A | 1.0485 | 1 | 0 | 0 | 0 |
| Aa | 0.449527 | 2 | 0 | 0 | 0 |
| Aaa | 0.36436 | 3 | 0 | 0 | 0 |
| C | 2.125201 | 0 | 0 | 1 | 0 |
| Cc | 2.168612 | 0 | 0 | 2 | 0 |
| Ccc | 2.037037 | 0 | 0 | 3 | 0 |
| Dd | 8.476445 | 0 | 0 | 0 | 2 |
| D | 2.224267 | 0 | 0 | 0 | 1 |
| Ddddd | 0.034427 | 0 | 0 | 0 | 5 |
Dataset2 (unpivot)
| Brand | SI | Attributes | Values |
| B | 0.839881 | B | 1 |
| Bb | 6.514407 | B | 2 |
| Bbb | 0.03975 | B | 3 |
| A | 1.0485 | A | 1 |
| Aa | 0.449527 | A | 2 |
| Aaa | 0.36436 | A | 3 |
| C | 2.125201 | C | 1 |
| Cc | 2.168612 | C | 2 |
| Ccc | 2.037037 | C | 3 |
| Dd | 8.476445 | D | 2 |
| D | 2.224267 | D | 1 |
| Ddddd | 0.034427 | D | 5 |
Suggest.
