Forum Discussion
Rows without data showing subtotals
You are welcome.
If you want to compare STSP with SP, maybe you can remove the third level, since the comparison at that level is meaningless.
If my solution works, please accept it and appreciate your kudos as well.
Super UserIn most cases, we start our data aggregation from the lowest level.
e.g.
Level 1: A
Levle 2: A1,A2
A1=10,A2=20, then A = 10+20=30
However, in your scenario, the value is assigned to higher level and skipped the lower level.
Then, the bottom-level data automatically inherits the values from the higher-level.
That's not what we do usually. And like what I mentioned before, since I am not familar to your business, so I am sorry that I can't tell you where you can improve in this scenario.
Thanks Ryan!
The thing is the two columns come from different places, and I want to compare the totals C and E between the two columns.
In the case of the first column (Sum of STSP), we've only the values from level C, which then provide the upper level E.
The second column (Sum of SP) is different, here we do have values for the lowest level F, which then adds up to C which then adds up to E.
Maybe this helps providing clarity, but otherswise it's ok you already helped a lot 🙂 Thanks!
- ryan_mayu
You are welcome.
If you want to compare STSP with SP, maybe you can remove the third level, since the comparison at that level is meaningless.
If my solution works, please accept it and appreciate your kudos as well.