Unfortunately there is no easy way to complete this currently.
I’ve seen a way to create subtotals but I don’t particular like it that much as it’s way too complex.
The best examples I have currently are below. I will also be covering financial reporting again during the next learning summit event.
I’m sure MS will be looking improving this (hopefully asap)
I’m certainly continuing to look for the best solution here. As soon as I have one I will be sharing it with all members.
Chrs
Sam