Forum Discussion
Need Help:compare different products with multiple slicer selection
Hi All,
I have a requirement where data is as follows.
I need to 1.Compare the Product supplier upon slicer selection
2.Please note Product Supplier<Plant<subPlant<Division<Subdivision all are hierarchy and comaprison should happen with them too.
3.I need to compare upon dynamic slicer selection which product supplier has lowest and which has highest bid and rest other calculations are also needed
<
| Product Supplier | Plant | Sub Plant | division | Subdivision | Cost | Trans Cost | Trans Cost |
| Ind 1 | A1 | AB-1 | D1 | SD-1 | 10000 | 10000 | 10000 |
| Ind 1 | A2 | AB-2 | D2 | SD-2 | 20000 | 20000 | 20000 |
| Ind 1 | A3 | AB-3 | D3 | SD-3 | 10000 | 10000 | 10000 |
| Ind 1 | A4 | AB-4 | D4 | SD-4 | 20000 | 20000 | 20000 |
| Ind 1 | A5 | AB-5 | D5 | SD-5 | 5000 | 5000 | 5000 |
| Ind 1 | A1 | AB-6 | D6 | SD-6 | 1000 | 1000 | 1000 |
| Ind 1 | A2 | AB-7 | D7 | SD-7 | 70000 | 70000 | 70000 |
| Ind 1 | A3 | AB-8 | D8 | SD-8 | 80000 | 80000 | 80000 |
| Ind 1 | A4 | AB-9 | D9 | SD-9 | 101000 | 101000 | 101000 |
| Ind 2 | A1 | AB-1 | D1 | SD-1 | 1000 | 1000 | 1000 |
| Ind 2 | A2 | AB-2 | D2 | SD-2 | 2000 | 2000 | 2000 |
| Ind 2 | A3 | AB-3 | D3 | SD-3 | 5000 | 5000 | 5000 |
| Ind 2 | A4 | AB-4 | D4 | SD-4 | 8000 | 8000 | 8000 |
| Ind 2 | A5 | AB-5 | D5 | SD-5 | 10000 | 10000 | 10000 |
| Ind 2 | A1 | AB-6 | D6 | SD-6 | 15000 | 15000 | 15000 |
| Ind 2 | A2 | AB-7 | D7 | SD-7 | 3000 | 3000 | 3000 |
| Ind 2 | A3 | AB-8 | D8 | SD-8 | 20000 | 20000 | 20000 |
| Ind 2 | A4 | AB-9 | D9 | SD-9 | 40000 | 40000 | 40000 |
| Ind 3 | A1 | AB-1 | D1 | SD-1 | 10000 | 10000 | 10000 |
| Ind 3 | A2 | AB-2 | D2 | SD-2 | 20000 | 20000 | 20000 |
| Ind 3 | A3 | AB-3 | D3 | SD-3 | 10000 | 10000 | 10000 |
| Ind 3 | A4 | AB-4 | D4 | SD-4 | 20000 | 20000 | 20000 |
| Ind 3 | A5 | AB-5 | D5 | SD-5 | 5000 | 5000 | 5000 |
| Ind 3 | A1 | AB-6 | D6 | SD-6 | 1000 | 1000 | 1000 |
| Ind 3 | A2 | AB-7 | D7 | SD-7 | 70000 | 70000 | 70000 |
| Ind 3 | A3 | AB-8 | D8 | SD-8 | 80000 | 80000 | 80000 |
| Ind 3 | A4 | AB-9 | D9 | SD-9 | 101000 | 101000 | 101000 |
| Ind 4 | A1 | AB-1 | D1 | SD-1 | 10000 | 10000 | 10000 |
| Ind 4 | A2 | AB-2 | D2 | SD-2 | 20000 | 20000 | 20000 |
| Ind 4 | A3 | AB-3 | D3 | SD-3 | 10000 | 10000 | 10000 |
| Ind 4 | A4 | AB-4 | D4 | SD-4 | 20000 | 20000 | 20000 |
| Ind 4 | A5 | AB-5 | D5 | SD-5 | 5000 | 5000 | 5000 |
| Ind 4 | A1 | AB-6 | D6 | SD-6 | 1000 | 1000 | 1000 |
| Ind 4 | A2 | AB-7 | D7 | SD-7 | 70000 | 70000 | 70000 |
| Ind 4 | A3 | AB-8 | D8 | SD-8 | 80000 | 80000 | 80000 |
| Ind 4 | A4 | AB-9 | D9 | SD-9 | 101000 | 101000 | 101000 |
| Ind 5 | A1 | AB-1 | D1 | SD-1 | 1000 | 1000 | 1000 |
| Ind 5 | A2 | AB-2 | D2 | SD-2 | 2000 | 2000 | 2000 |
| Ind 5 | A3 | AB-3 | D3 | SD-3 | 5000 | 5000 | 5000 |
| Ind 5 | A4 | AB-4 | D4 | SD-4 | 8000 | 8000 | 8000 |
| Ind 5 | A5 | AB-5 | D5 | SD-5 | 10000 | 10000 | 10000 |
| Ind 5 | A1 | AB-6 | D6 | SD-6 | 15000 | 15000 | 15000 |
| Ind 5 | A2 | AB-7 | D7 | SD-7 | 3000 | 3000 | 3000 |
| Ind 5 | A3 | AB-8 | D8 | SD-8 | 20000 | 20000 | 20000 |
| Ind 5 | A4 | AB-9 | D9 | SD-9 | 40000 | 40000 | 40000 |
| Ind 6 | A1 | AB-1 | D1 | SD-1 | 10000 | 10000 | 10000 |
| Ind 6 | A2 | AB-2 | D2 | SD-2 | 20000 | 20000 | 20000 |
| Ind 6 | A3 | AB-3 | D3 | SD-3 | 10000 | 10000 | 10000 |
| Ind 6 | A4 | AB-4 | D4 | SD-4 | 20000 | 20000 | 20000 |
| Ind 6 | A5 | AB-5 | D5 | SD-5 | 5000 | 5000 | 5000 |
| Ind 6 | A1 | AB-6 | D6 | SD-6 | 1000 | 1000 | 1000 |
| Ind 6 | A2 | AB-7 | D7 | SD-7 | 70000 | 70000 | 70000 |
| Ind 6 | A3 | AB-8 | D8 | SD-8 | 80000 | 80000 | 80000 |
| Ind 6 | A4 | AB-9 | D9 | SD-9 | 101000 | 101000 | 101000 |
>
Currently I Can't thing beyond 2 independent slicers and different visuals
Expected output :If suppose Supplier IND4 and IND6 all the metric difference should be shown along with hierarchy
1 Reply
- lbendlin
Super User
This can probably be done in the UI, no need for formulas.
Your sample data is not granular enough to make any judgement.
Maybe you can provide better sample data.
