Forum Discussion
mdufresne34
3 years agoFrequent Visitor
Cumulative Sum using different tables
Hello everyone ! I am trying to get the cumulative sum of values from 2 different column using TOTALYTD. Sometimes the values from the 1st column are missing, in that case i want to use the va...
Anonymous
3 years agoNot applicable
HI mdufresne34,
AFIAK, current the time intelligence functions does not support complex customize. I'd like to suggest you use date function to manually define these calculate date ranges.
Time Intelligence "The Hard Way" (TITHW)
Regards,
Xiaoxin Sheng
- mdufresne343 years agoFrequent Visitor
Hello, Than you for your response, do you know if i could do this without time intelligence ? I tried using the link you provided but I couldn't adapt it to my problem