Pivot Tables Doesn't List Repeating Values Once

[DashboardNovice]

In the attached file, columns A:D contains the results of a pivot table. These fields are in the 'Rows' box of the Pivot Table fields window. Since columns A:B repeat, they should only be listed once, then list the total hours and amount. The total hours and amount fields are in the 'Values' box of the Pivot Table fields window. The total hours and amount are definitely 'SUMMED.'

The orange columns in F:I is the result that I was expecting. I have another similar pivot table which produces the desired result where the values in columns A:B are listed only once. So I don't know what is wrong with this particular pivot table.

Can anybody offer any suggestions?

 

[Nebu]

Hi:

Find the attached.

Thanks

 

[DashboardNovice]

Hi:

Find the attached.

Thanks

Interesting. It worked. Thank you. I'm still curious to know why the other pivot table I was referring to did work, even though that one didn't have the same solution you used.

 

[Nebu]

Hi:

Your Bill rate is not exactly $77.51



So the layout you had for other pivots will not work here.

Thanks