So basically, I am trying to edit a dashboard that someone who left my company made. I want to add a row at the end of the upper table in Image 1 that says Gross Profit, which will of course just be Turnover - Cost of Sales.
In fact, a measure with that calculation called "Gross Profit" is already in the fields (see Image 4). When this is checked along with other measures and put in "Values", it produces the lower table (see Image 2). This is what I would like to be seen in the upper table.
Of course, the problem with that is that in the upper table (Image 1), each row is a Group, made up of Lines (See Image 3), and in order to add "Gross Profit" I'd have to create a Calculated Line that calculates Turnover - Sales for every single date. That would take far too much time.
When I do check the Gross Profit measure when on the upper table, it just looks like Image 3, with Gross Profit added as a column total after every Amount.
Is there any easy fix where I can add Gross Profit as a row in the upper table, like how it is in the lower table (Image 2)?
Thanks for reading.
