https://community.qlik.com/t5/QlikView/Dates-in-Pivot-Tables/m-p/1547598#M509089 <P>Good Morning,&nbsp;</P><P>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?&nbsp;</P> Thu, 21 Feb 2019 15:12:16 GMT JustinRamsey 2019-02-21T15:12:16Z https://community.qlik.com/t5/QlikView/Dates-in-Pivot-Tables/m-p/1547598#M509089 <P>Good Morning,&nbsp;</P><P>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?&nbsp;</P> Thu, 21 Feb 2019 15:12:16 GMT https://community.qlik.com/t5/QlikView/Dates-in-Pivot-Tables/m-p/1547598#M509089 JustinRamsey 2019-02-21T15:12:16Z https://community.qlik.com/t5/QlikView/Dates-in-Pivot-Tables/m-p/1547620#M509090 <P>I suggest to create a master-calendar and to use whose period-fields: <A href="https://community.qlik.com/t5/QlikView-Documents/How-to-use-Master-Calendar-and-Date-Values/ta-p/1495741" target="_blank" rel="noopener">How-to-use-Master-Calendar-and-Date-Values</A>.</P><P>- Marcus</P> Thu, 21 Feb 2019 15:44:51 GMT https://community.qlik.com/t5/QlikView/Dates-in-Pivot-Tables/m-p/1547620#M509090 marcus_sommer 2019-02-21T15:44:51Z