Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
just add one extra column
RangeSum(Above(Sum(Sales), 0, RowNo()))
use it as ur measure
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