Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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?