Pivot table help

[e_nnm_m]

I am running excel 2013 on a PC.

I built a tracker spreadsheet and formatted it into a table. Example:

Product_Num	Team1_In	Team1_Out	Team2_In	Team2_Out
1234	8/3/20	8/5/20	8/7/20	8/10/20
6789	9/2/20	9/4/40	9/6/20
6538	9/15/20	9/17/20

The problem is when I insert a pivot table, the empty cells seem to be removing the grouping on the pivot tables, so that all the Januarys are combined, instead of it being grouped by years and then months.

Is there a work-around?

Thanks.

 

[sandy666]

Expected result?

 

[e_nnm_m]

Expected result?

I have hidden columns in the worksheet that calculate the number of work days in each team. I have a it set to a 0 if there is no date in the IN column, or TODAY minus the in_date otherwise. The pivot table summarizes the average days of each product by team.

 

[sandy666]

you didn't show representative example
so I can't help