Forum Discussion

3rdcycle's avatar
3rdcycle
Frequent Visitor
9 years ago
Solved

TOTALYTD not working

No matter what I try, I can't get a simple cumulative sum using TOTALYTD to work. I've read the dozend or so other threads with the same issue but nothing helped so far. Total YTD always just shows t...
  • MFelix's avatar
    MFelix
    9 years ago

    Hi 3rdcycle,

     

    The question is that you are making a YTD column, you must use the TOTALYTD as a measure, there is a big difference in making the use of the formula in a column or in a measure based on it's context.

     

    Create a new measure with the same formula and add it to your visuals and should give the expected results.

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Icon for Super User rankSuper User
9 years ago

Hi 3rdcycle,

 

The question is that you are making a YTD column, you must use the TOTALYTD as a measure, there is a big difference in making the use of the formula in a column or in a measure based on it's context.

 

Create a new measure with the same formula and add it to your visuals and should give the expected results.

 

Regards,

MFelix

3rdcycle's avatar
3rdcycle
Frequent Visitor
9 years ago

Thanks! This works, even though I could swear I saw a video where someone added a cumulative sum column using TOTALYTD.

 

The only problem now is that my Calendar contains future dates causing TOTALYTD to compute results all the way to the end of the year instead of to today (as the name would imply). Any solution for this?