Configuring Pivot table to display certain data

Hi:

Please refer to attached sheet.
I am using the pivot table as shown.
Column K shows Week#
Column L shows the total hours worked in that week.
I need to see if it is possible to configure the pivot table so to display weekly data only which has over 40 hours.


Please help.

Let me know if you have any questions.

Thanks

Riz

i cant get your PT to show total hrs/person/week over 40, but you could use this formula, in J, copied down.

=IF(AND(B2=B1,I2=I1),"",IF(SUMIFS(E:E,I:I,I2,B:B,B2)<40,"",SUMIFS(E:E,I:I,I2,B:B,B2)))

it sums empl hrs by empl name, week number and IF their hrs/week are greater than 40

let me know if this is something you can work with?

glad to help and thx for the rep