New “Sample Pivot Tables from HCM Query” guide

posted Jan 22, 2019, 1:12 PM by Peyri Herrera

The CRC has published a new guide for using pivot tables to analyze PeopleSoft HCM data. This guide includes basic directions for creating a pivot table plus several sample Excel pivot table configurations for the M_HR_EE_VALIDATION_DIST_PROMPT query to look at Job Data and Position. We introduce additional steps you can take to help you view your data: Change the style (colors/lines), add percentages next to the counts, sort the results, and apply conditional formatting. This job aid should be considered as a resource to learn about your options for analyzing your HCM data. For more information about pivot tables, please refer to Excel help and online resources like Excel Easy - Pivot Tables and Microsoft - Create a PivotTable to analyze worksheet data.

Guide: Sample Pivot Tables for M_HR_EE_VALIDATION_DIST_PROMPT v1.1.pdf (posted on the CRC Guides & Job Aids page in the “Query - Other” section)

Pivot table basics