Pivot table, IF function in a calculation
Solved
margir4233
Posted messages
67
Registration date
Status
Membre
Last intervention
-
margir4233 Posted messages 67 Registration date Status Membre Last intervention -
margir4233 Posted messages 67 Registration date Status Membre Last intervention -
Hello,
Quick question for you. Is it possible to create an IF function in a pivot table?
My pivot table shows the sum of hours per employee per week. I would like to assign an IF function to differentiate between regular hours and overtime hours.
For example:
Regular hours: If number of hours > 40, 40, number of hours
Overtime hours: If number of hours > 40, number of hours - 40
Thank you for your help.
Quick question for you. Is it possible to create an IF function in a pivot table?
My pivot table shows the sum of hours per employee per week. I would like to assign an IF function to differentiate between regular hours and overtime hours.
For example:
Regular hours: If number of hours > 40, 40, number of hours
Overtime hours: If number of hours > 40, number of hours - 40
Thank you for your help.
