Forum Discussion
Need help on a Row level data Calculation
Hi Friends, I need some help with this calculation, Don't know how to make this work I have data in the following format Year Month Revenue MTD Revenue 2020 4 489,611 ...
Hi @camargos,
sorry, I missed explaining something,
Column D should be my Result
This report has a filter on Year so when I put a filter on Year the Column D should populate automatically based on calculation.
| Year | Month | Revenue | MTD Revenue |
| 2020 | 4 | 489,611 | |
| 2020 | 5 | 308,211 | 31,404 |
| 2020 | 6 | 277,696 | 991 |
| 2020 | 7 | 277,696 | 20,907 |
| 2020 | 8 | 284,882 | 28,899 |
| 2020 | 9 | 274,322 | 5,106 |