If I try to do it with a straight table, the first problem I'm faced with is that expressions (net sales value, cost of matereial,...) appear in the columns instead of the rows. How can I transpose it?
Second is that I don't know how to show values and percentages in 2 columns at a time. I can group the expressions in pairs (values with percentages) and cycle between them but I want to see both at a time.
Re: Profit and loss statement: value and percentage
The structure of my database is something like one record for each sales line with these fields:
COST OF MATERIAL
And I want to have the P&L as shown above. Besides there will be list boxes with customers, countries, products, etc. so I can filter the scope of the P&L.
Actually, I imagine this like a table with no dimensions and only expresions, some of them showing sum(field x) and others sum(field x)/sum(sales field). Problem is: How to show the expressions in pairs within 2 columns?