Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Summing lines in a dimension to create a P&L

I have attached an example of some profit and loss data.

I want to add sales and cost of sales to give gross margin

then gross margin added to overheads to give profit before tax

then profit before tax to taxation to give profit after tax so that i get a profit and loss account as follows

Sales

Cost of Sales

Gross Margin

Overheads

Profit before Tax

Tax

Profit after tax

Any ideas?

Thank you

2 Replies
Not applicable
Author

Reload the data to get the costs as negative numbers

Not applicable
Author

I think I am nearly there with this new example but not quite. Any idea why the sums are not working for each type?