Long Time No See Excel Gurus

[pdw137]

I am working with a Classic Pivot Table and have one thing that is troubling me.

I have grouped my data and got things displaying however only the first record of each group is populated (displayed)

Groupings/Row Labels Data Values Over Here

Field1 Field2 Field3
3 1 1
0
0 1
0
2 1 1
0
0 1
0
1 1 1
0
0 1
0

What I would like to see is:

Field1 Field2 Field3 Data Values Over Here
3 1 1
3 1 0
3 0 1
3 0 0
2 1 1
2 1 0
2 0 1
2 0 0
1 1 1
1 1 0
1 0 1
1 0 0

This is much more readable. Anyone know if this is possible?

Appreciate any tips or insights here.

Thanks.

Pete

 

[sachavez]

Right click on your pivot table, then select pivot table options, then add a zero where it says show empty cells as: