Question: how to do ytd in pivot table?
Answer: Right-click any value within the target field. ... 
Select Value Field Settings. ... 
Click the Show Values As tab.
Select Running Total In from the drop-down list.
In the Base Field list, select the field that you want the running totals to be calculated against. ... 
Click OK to apply your change.