depends on the structure of your input data.
it could look like this (see .qvw file attached)
ProfitAndLoss.qvw 150.8 K
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?
Thanks to all.
Regarding transposing columns, go to properties>presentation> check the box 'horizontal'.
Concerning the proportions you'd like to show, here are a couple options:
1) Properties>expressions> check the box relative
2) Try a formula like sum(your_field)/sum(TOTAL your_field)
Hope that helps.