I have created a year to date formula in Power Pivot to get the Sales cumulated month by month. When I create a pivot table it happens what it is shown in the picture below. When on the month to date I have no turnover the year to date formula doesn´t give me a value (but it should give me the same value of the month before).
On the power pivot this is my formula:
YTD TGS:=TOTALYTD(SUM(DF_GRID_1[_TGS]);DF_GRID_1[Date Dummey];ALL(‘Date Table1’)).
Can somebody help me? Thank you!
On the power pivot this is my formula:
YTD TGS:=TOTALYTD(SUM(DF_GRID_1[_TGS]);DF_GRID_1[Date Dummey];ALL(‘Date Table1’)).
Can somebody help me? Thank you!
