I'm trying to create a cumulative sum for YTD based on a user's selection
The user selects PeriodYear (an integer value), PeriodMonth (integer from 1-12), so I would like the sum(Amount) from month 1 to the users selection. I've been trying solutions suggested online and I simply can't get this to work, any help would be really appreciated.
There is another field selected. Because of another issue with the data set, I have had to create a filter to only show data relating to the latest load date, called Calendar 1. I'm just doing some testing, please bare with me