I've built a P&L table using a Simple Table. The result is the one that follows:
|200||Cost of sales||- 75.000||- 75%|
|300||Gross Profit||- 25.000||- 25%|
I want to calculate the column "Percentage" but I don't know how to manage with it.
I tried to use the following expression but it did't work: sum(Amount) / sum(total <Level> if(Level=100, Amount))
Can somebody help me?
Thanks in advance.