Hi there,
I need help from you guys.
I want to create a custom P&L. Unfortunately, I can´t figure out the design part.
My current version in excel has the following structure:
example structure
So far, I was able to add Ranks and Categories to my Dataset, so I can have a correct order of my accounts. Unforunately, I have a big issue with subtotals as you can see on the screenshot.
my current version in DOMO

Is it somehow possible to add custom totals, which I can move freely?
On my example screen, I would like to have a total under Ranking 3, which contains ranking 1 + ranking 2 + ranking 3.
Under ranking 6 for example should be a total of ranking 1 +2 +3 + 4 + 5 + 6
Furthermore, does someone know if I can hide the ranking column, it is just implemented for clustering accounts.
I hope I was clear enough with my problem, it is a bit difficult to describe.
Many thanks!