topic I can't figure out how to create a pivot table. I want to have a column for the total sales in every month, broken out by region and product. Can you help? in Alteryx Designer Cloud Discussions https://community.alteryx.com/t5/Alteryx-Designer-Cloud-Discussions/I-can-t-figure-out-how-to-create-a-pivot-table-I-want-to-have-a/m-p/1128644#M323 Thu, 04 Jan 2018 01:00:26 GMT 4a449ebf5e0b5283b640 2018-01-04T01:00:26Z I can't figure out how to create a pivot table. I want to have a column for the total sales in every month, broken out by region and product. Can you help? https://community.alteryx.com/t5/Alteryx-Designer-Cloud-Discussions/I-can-t-figure-out-how-to-create-a-pivot-table-I-want-to-have-a/m-p/1128644#M323 Thu, 04 Jan 2018 01:00:26 GMT https://community.alteryx.com/t5/Alteryx-Designer-Cloud-Discussions/I-can-t-figure-out-how-to-create-a-pivot-table-I-want-to-have-a/m-p/1128644#M323 4a449ebf5e0b5283b640 2018-01-04T01:00:26Z Re: I can't figure out how to create a pivot table. I want to have a column for the total sales in every month, broken out by region and product. Can you help? https://community.alteryx.com/t5/Alteryx-Designer-Cloud-Discussions/I-can-t-figure-out-how-to-create-a-pivot-table-I-want-to-have-a/m-p/1128645#M324 <P>The easiest way to do this is by using the aggregate rows transformation with the sum function, this will sum total sales for you. Then below, you can group by month, region and product. </P><P>&nbsp;</P><P>&nbsp;</P> Wed, 10 Jan 2018 14:44:41 GMT https://community.alteryx.com/t5/Alteryx-Designer-Cloud-Discussions/I-can-t-figure-out-how-to-create-a-pivot-table-I-want-to-have-a/m-p/1128645#M324 Trifacta_Alumni 2018-01-10T14:44:41Z