YTD calculation

[#1]

Hi,

I have only year and month fields. and on selection of year and month, it should give me the addition of  consecutive months (january onwards, upto selected month/year)

For ex, on selecting 2014 March, i want sum of January2014 + february 2014 + march 2014 value.

How can it be done

Thanks.

[ashfaq_haseeb]

Hi,

If you reply via inbox you don't see that option.

try to open it in a new window.

Then click on reply, then you will see advance editor on bottom right.

Regards

ASHFAQ

[#3]

[#4]

Thanks

Please check the attached qvw

[ashfaq_haseeb]

Check this

Regards

ASHFAQ

[tresesco]

Try:

=Sum({<Year={$(=only(Year))},Month_Name, Month={"<=$(=Max(Month))"}>} [DS1Volume])

Like this, Month_Name field selection is disregarded to get your YTD.

[PrashantSangle]

Hi,

Please find attached example.

Regards

[#8]

but this way i get values for month Jan and Feb, and not the sum of Jan + Feb.

How do i find the sum of jan+ feb in ytd1 column for Selection Feb 2014

[ashfaq_haseeb]

Try like this

Sum({<Year={"=$(=max(Year))"},Month_Name=,Month={"<=$(=Max(Month))"}>}[DS1Volume])

Regards

ASHFAQ

[tresesco]

Yes, if you have Month in the dimension, you have play a trick, like:

=RangeSum(Above(Sum({<Year={$(=only(Year))},Month_Name, Month={"<=$(=Max(Month))"}>} [DS1Volume]),0, RowNo(Total)))

[#11]

No, it doesnt provide me the sum.