Forum Discussion
P&L Waterfall
Community hi,
Did someone create P&L Waterfall?
I have measures (It's simple calculation):
Total income
COGS
Gross profit
Expenses1
Expenses2
Expenses3
Expenses4
Expenses5
Net operating income
I want to display this in a waterfall
Example of my data:
| Period | Metrics | Value |
| 2021-01 | Total Revenue | 5 000 000,00 |
| 2021-01 | COGS | 450 000,00 |
| 2021-01 | Gross Profit | 4 550 000,00 |
| 2021-01 | Ex1 | 300 000,00 |
| 2021-01 | Ex2 | 200 000,00 |
| 2021-01 | Ex3 | 150 000,00 |
| 2021-01 | Ex4 | 200 000,00 |
| 2021-01 | Ex5 | 400 000,00 |
| 2021-01 | Net Operating Profit | 3 300 000,00 |
| 2021-02 | Total Revenue | 8 000 000,00 |
| 2021-02 | COGS | 480 000,00 |
| 2021-02 | Gross Profit | 7 520 000,00 |
| 2021-02 | Ex1 | 400 000,00 |
| 2021-02 | Ex2 | 200 000,00 |
| 2021-02 | Ex3 | 250 000,00 |
| 2021-02 | Ex4 | 200 000,00 |
| 2021-02 | Ex5 | 400 000,00 |
| 2021-02 | Net Operating Profit | 6 070 000,00 |
| 2021-03 | Total Revenue | 4 500 000,00 |
| 2021-03 | COGS | 450 000,00 |
| 2021-03 | Gross Profit | 4 050 000,00 |
| 2021-03 | Ex1 | 100 000,00 |
| 2021-03 | Ex2 | 200 000,00 |
| 2021-03 | Ex3 | 150 000,00 |
| 2021-03 | Ex4 | 200 000,00 |
| 2021-03 | Ex5 | 200 000,00 |
| 2021-03 | Net Operating Profit | 3 200 000,00 |
| 2021-04 | Total Revenue | 5 000 000,00 |
| 2021-04 | COGS | 250 000,00 |
| 2021-04 | Gross Profit | 4 750 000,00 |
| 2021-04 | Ex1 | 300 000,00 |
| 2021-04 | Ex2 | 200 000,00 |
| 2021-04 | Ex3 | 250 000,00 |
| 2021-04 | Ex4 | 200 000,00 |
| 2021-04 | Ex5 | 400 000,00 |
| 2021-04 | Net Operating Profit | 3 400 000,00 |
