value per month

[beck_bakytbek]

Hi Folks,

i got a Question: my data do look like

jan, 100

Feb, 120

March, 140

Apr, 160

Mai, 170

my expected Output is:

if i select: March so then i should have the sum : Jan + Feb + March

and if i select Mai : i should have the Sum: Jan + Feb + March + April + Mai

Does anybody have any ideas?

Thanks a lot

Beck

[Channa]

just add one extra column

RangeSum(Above(Sum(Sales), 0, RowNo()))

use it as ur measure

[beck_bakytbek]

Hi Channa,

thanks a lot for your help and Feedback, i know this Expression,

i have a Question what if, i select value from month Jan untill month Mai whithin of year 2019, but i should consider the values from year 2018

for instance:

Year 2018 = 1500

Year 2019:

Jan, 10

Feb, 12

Mrc, 15

Apr, 12

Mai, 15

if i select the month from Jan untill Mai i should see the sum of 1500 + 10 + 12 + 15 + 12 + 15

Do you have any idea?

Thanks a lot