Hello Everyone,
I need some help, i'm building a report to review the year information and I need to have a structure of a waterfall between months.
On the picture below, the first month has an "ending balance" calculated by the grand total, and this needs to show up as the initial balance for month 2 and be considered as part of the calculation to the ending balance of month 2 forward…
Does anyone have an idea on how to do it using formulas on the dataset?
Best regards,
Fabio Sarmento