Dates in Pivot Tables

[JustinRamsey]

Good Morning, 

I am working with sales data from our ERP (SAP). I am wanting to create a Pivot with total sales per month per team member. However, the data is for each individual date and not combined into months. Can you combine the dates into the months like January 2019 in the Pivot table itself? If not what would be the script to convert it on data load? 

[marcus_sommer]

I suggest to create a master-calendar and to use whose period-fields: How-to-use-Master-Calendar-and-Date-Values.

- Marcus