Forum Discussion

Austinehype's avatar
Austinehype
Helper I
5 years ago

Cummulative calculation

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

 

 

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

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