Hiding lines in a table for financial reporting

[ScotiaTheOne]

Hi guys,

I’m creating a report with the below format, it’s pretty standard for financial reporting. I’m looking for 

• a way to hide the ‘Payout’ line without excluding it from the calculation
• any ideas how best to present this in tabular format, just incase I’m missing something using the out-of-the-box ‘Table’ format

Any help appreciated

Turnover	100
Cost of Sales	-50
Gross Margin	50
Other Costs	-20
Net Margin	30