Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Pivot Tables
I've created a pivot table for one of our clients with a DSN connection back to their ERP data in SQL 2008. At a high level, the pivot tables are pretty amazing, but I've reached two hurdles that I can't figure out if there is a solution.
We are dealing with payroll check details. For each check, there is a record for every type of pay an employee receives. The power is that we can filter to user-specific types of pay for user-specific periods. My challenges:
- Is there any way a user-specified column can be added to a pivot table without breaking the link to the source data? For example, if we filter to 4 check dates and are displaying hours worked for each pay type as a column with a row total for all pay types, and want to get an average number of hours worked (row total / 4)
- Is there a way to filter the data based on a total value? For example, in the above scenario, where we want to display only employees that worked an average of 30 hours or more per week.
I've noticed the PowerPivot add-on. Curious if that adds a more dynamic user-friendly front to the pivot table functionality that would allow the above changes.
Cindy
