Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello all,
I am Trying to sum the values at Hierarchy (Product A = Material A +Material B+ Material C) where as (Material A = 10) which inturn is the summed value.( Material A= Element 1+ Element2+ Element3). Total is the sum of values across product A (Total = Area1 +Area2 +Area3+..). How to show this calculation in Matrix Visualization.
Thanks for your help,
Shashi
Product\Location | Area1 | Area2 | Area3 | Area4 | Total | ||
Product A | 40 | 10 | 0 | 40 | 90 | ||
MaterialA | 10 | 0 | 0 | 10 | 20 | ||
Element1 | 5 | 0 | 0 | 0 | 5 | ||
ELement2 | 5 | 0 | 0 | 0 | 5 | ||
Element3 | 0 | 0 | 0 | 10 | 10 | ||
MaterialB | 20 | 10 | 0 | 20 | 50 | ||
MaterialC | 10 | 0 | 0 | 10 | 20 | ||
Product B | 30 | 30 | 10 | 0 | 70 | ||
MaterialD | 10 | 10 | 0 | 0 | 20 | ||
MaterialE | 20 | 20 | 10 | 0 | 50 |
That should be standard matrix functionality. You get the level specific row totals and grand totals for free.
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |