Cummulative calculation

[Austinehype]

Hi!

I have a list of data where I need to sum the revenues of 3 product types and then multiply with a specified multiplier cumulatively.

3 Measures:

1. Measure: Sum the last month's total revenues and then multiply with the specific multipliers based on the product type it could be 40% or 60%

2. Measure Sum the 2 months ago total revenues and do the same

3. Measure sum the 3 months ago total revenues and do the same

[lbendlin]

@Austinehype Please provide sample data in usable format (not as a picture - maybe insert into a table?) and show the expected outcome.