idea Crosstab Query in ArcGIS Pro Ideas https://community.esri.com/t5/arcgis-pro-ideas/crosstab-query/idi-p/931477 <HTML><HEAD></HEAD><BODY>A tool that allows you to crosstab data for analysis would be useful.&nbsp; In MS Access you can create crosstab queries which are useful for&nbsp;summarizing data over time based on a whole set of parameters.&nbsp; Very often I find myself creating data or maintaining planning related datasets in personal geodatabases because I can easily create crosstab queries inside the Access backend.&nbsp; However, this is impossible if the data is stored inside a file geodatabase because you can't access the backend data through MS Access. <!-- content transformation source ID: 087E00000004Fhc --> </BODY></HTML> Fri, 22 Jun 2012 16:56:17 GMT ChrisRumig 2012-06-22T16:56:17Z Crosstab Query https://community.esri.com/t5/arcgis-pro-ideas/crosstab-query/idi-p/931477 <HTML><HEAD></HEAD><BODY>A tool that allows you to crosstab data for analysis would be useful.&nbsp; In MS Access you can create crosstab queries which are useful for&nbsp;summarizing data over time based on a whole set of parameters.&nbsp; Very often I find myself creating data or maintaining planning related datasets in personal geodatabases because I can easily create crosstab queries inside the Access backend.&nbsp; However, this is impossible if the data is stored inside a file geodatabase because you can't access the backend data through MS Access. <!-- content transformation source ID: 087E00000004Fhc --> </BODY></HTML> Fri, 22 Jun 2012 16:56:17 GMT https://community.esri.com/t5/arcgis-pro-ideas/crosstab-query/idi-p/931477 ChrisRumig 2012-06-22T16:56:17Z Re: Crosstab Query https://community.esri.com/t5/arcgis-pro-ideas/crosstab-query/idc-p/931478#M2983 <HTML><HEAD></HEAD><BODY>I may be wrong, but the "Pivot Table" tool in the Toolbox may accomplish the crosstab that you want, under a different name. Have you tried it? <!-- content transformation source ID: 00aE0000000V89p --> </BODY></HTML> Tue, 26 Jun 2012 13:17:48 GMT https://community.esri.com/t5/arcgis-pro-ideas/crosstab-query/idc-p/931478#M2983 DavidKnudsen 2012-06-26T13:17:48Z Re: Crosstab Query https://community.esri.com/t5/arcgis-pro-ideas/crosstab-query/idc-p/931479#M2984 <HTML><HEAD></HEAD><BODY>It's worth emphasising that the Pivot Table tool is an <EM>ArcInfo</EM> licensed tool so of&nbsp;no use to us lesser mortals. <!-- content transformation source ID: 00aE0000000V8Bb --> </BODY></HTML> Tue, 26 Jun 2012 13:49:09 GMT https://community.esri.com/t5/arcgis-pro-ideas/crosstab-query/idc-p/931479#M2984 DuncanHornby 2012-06-26T13:49:09Z Re: Crosstab Query - Status changed to: Closed https://community.esri.com/t5/arcgis-pro-ideas/crosstab-query/idc-p/1224056#M21787 <P>This idea has been closed as a duplicate of the Data Management Idea linked below. Don't worry, you can still show your support by commenting and adding kudos to the open idea. Thanks for your contributions!</P><P><A href="https://community.esri.com/t5/data-management-ideas/crosstab-query/idi-p/922384" target="_blank">https://community.esri.com/t5/data-management-ideas/crosstab-query/idi-p/922384</A></P> Thu, 20 Oct 2022 20:49:34 GMT https://community.esri.com/t5/arcgis-pro-ideas/crosstab-query/idc-p/1224056#M21787 SSWoodward 2022-10-20T20:49:34Z