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.