I want to insert calculated rows to a power BI matrix. How do i add this?
I can add calculated columns. But not sure how to structure the data and what are the functions to use to do this;
2018 | |
Vol(KG) | 100 |
Turnover | 12,000 |
Cost | (8,000) |
Gross Profit | 4,000 |
Cost/KG | 40 |
Gross margin | 33.3% |
This is what the matrix should look like. Cost/KG and Gross margin are calculated using above rows.
Please assist