Forum Discussion
QQQ
Advocate II
Advocate IITOTALYTD does NOT take cumulative
TOTALYTD acts as sum for each time period rather than a cumulative. I have a separate Calendar table in Power Pivot and I created relationship with my main table. Here is the formula YTD_...
Hello nickchobotar TomMartens Interkoubess
Thank you all for the quick and helpful responses.
I just realized my Months in Pivot Table was from wrong table. Instead of getting it from Data table (which I named 'Calendar'), I got it from the Facts table.
Below is the updated table
nickchobotar
Skilled Sharer
Skilled SharerHelloQQQ
Your formula is correct and it should work.
Could you please check 2 things:
1) Is your Calendar table marked as Date Table (Design Tab in Power Pivot)
2) All the dates in your Calendar table must be consecutive dates, no gaps.
N -
QQQAdvocate II
Advocate IIYes, both conditions are true