Forum Discussion
3rdcycle
9 years agoFrequent Visitor
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...
- 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
Super User
9 years agoHi 3rdcycle,
The TOTALYTD does not compute until the end of the year computer from the beginning of the year until the selected date what usually happens is that if your data finish in July and you have your visuals until December the August till December will always show the same value.
Don't understand what is your question.
MFelix