View original (French)

Pivot table, IF function in a calculation

Solved
margir4233 Posted messages 67 Registration date   Status Member Last intervention   -  
margir4233 Posted messages 67 Registration date   Status Member 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.

3 answers

  1.
    via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759
     
    Hello

    In your Pivot Table, click on the title of your Hours column, then in the Ribbon under PivotTable Tools, select Formulas, then Calculated Field, and build your IF formula

    Best regards
    Via

    -- "Imagination is more important than knowledge." A. Einstein
    0