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.
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!
Super UserYou 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.