Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a situation where I have a 2-level hierarchy
Channel
Sub Channel
On the report I show
Channel Actual Pct to Plan YoY
Sub-Channel 1
Sales Type 1
Sales Type 2
Sales Type 3
PCT to measure
Sub-Channel 2
Sales Type 1
Sales Type 2
Sales Type 3
Pct to measure
Is there a way to have the Channel (Higher level) to get the grid to look like this. I standard total doesn't make sense since Sales Type 2 Actual is a subset of Sales Type 1 and Sales Type 3 is a different measure all together.
The users want something like this where Channel is the sum of any and all sub channels. Need to do this in a single visual instead of "stacking" (for export)
Hi @Anonymous ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share your data sample as table format so that I could have a test on it.
Best Regards,
Cherry
Was not what I was looking for. I need "detail" rows at the higher level at the same time as the "Lower" level rows in the hierarchy. Where Parent Metric 1 = Child 1 Metric 1 + Child 2 Metric 1 , etc.
Parent
Metric 1
Metric 2
Metric 3
Child 1
Metric 1
Metric 2
Metric 3
See if this helps:
Matrix Measure Total Triple Threat Rock & Roll
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |