You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Simple Math on a Pivot Table

edited Jul 15, 2021 6:26PM in Reporting and Analytics for HCM 1 comment

Summary

I need some help with some math that I might be overcomplicating.

Content

I have created a pivot table that groups employees into temporary, seasonal and regular table and within the tables, I have separated the employees into groups based on the most recent action code: 'layoff', 'leave of absence', 'other (includes all actions that an active employee could have)'.

 I would like to produce a final total for each group (temporary, seasonal and regular) that showcases the amount of 'active' employees per group which I would ultimately get by: (total amount of seasonal employees - (seasonal layoff employees - seasonal leave of absence employees) )

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!