Is it possible to substitute a total for another number?
I have a series of data over time. For the first 2 years i can use the calculation...
SUM([cvps]) / TOTAL(SUM([cvps]))
RUNNING_SUM([1 - % of Total])
to work out the cumulative % increase overtime to the total number.
For the third year I have the same data but would want to substitute the TOTAL(SUM([cvps])) with another column from the data that contains a forecast. I have tried using an if statement to do this but am not having much success.
Should I try bringing in this other data as a separate source and joining it or do something else?