I have the table below to calculate clv on our customer base over time, the problem im running into is that the total column is including values I dont want (i need the total to be the sum of the column) but it is including the sum of months not present in that column. For example the total for each colour is not excluding the underlined.
The Calculation for running is runningSum(sum(amount),[createdate DESC],[createdate])
Any suggestions?
Can you partition by DateMonth?
runningSum(sum(amount),[createdate DESC],[createdate,DateMonth])
Unfortunately that sums down but then doesnt sum across.
Can you try without partitions then?