idea Crosstab Query in Data Management Ideas https://community.esri.com/t5/data-management-ideas/crosstab-query/idi-p/922384 <P>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.</P><!-- content transformation source ID: 087E00000004Fhc --> Thu, 01 Sep 2022 19:14:56 GMT ChrisRumig 2022-09-01T19:14:56Z Crosstab Query https://community.esri.com/t5/data-management-ideas/crosstab-query/idi-p/922384 <P>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.</P><!-- content transformation source ID: 087E00000004Fhc --> Thu, 01 Sep 2022 19:14:56 GMT https://community.esri.com/t5/data-management-ideas/crosstab-query/idi-p/922384 ChrisRumig 2022-09-01T19:14:56Z Re: Crosstab Query https://community.esri.com/t5/data-management-ideas/crosstab-query/idc-p/922385#M105 <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/data-management-ideas/crosstab-query/idc-p/922385#M105 DavidKnudsen 2012-06-26T13:17:48Z Re: Crosstab Query https://community.esri.com/t5/data-management-ideas/crosstab-query/idc-p/922386#M106 <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/data-management-ideas/crosstab-query/idc-p/922386#M106 DuncanHornby 2012-06-26T13:49:09Z Re: Crosstab Query https://community.esri.com/t5/data-management-ideas/crosstab-query/idc-p/1390958#M2356 <P><A href="https://community.esri.com/t5/arcgis-pro-ideas/pivot-table-chart-style-in-arcgis-pro/idc-p/1390953" target="_self">Pivot Table Chart Style in ArcGIS Pro</A></P> Tue, 05 Mar 2024 07:35:04 GMT https://community.esri.com/t5/data-management-ideas/crosstab-query/idc-p/1390958#M2356 Bud 2024-03-05T07:35:04Z