Help on Pivot table

[student]

When i do pivot i get the data displayed as

Contractor Circle Count
X 1 10
2 15
3 20
Y 1 10
2 15
3 20
Z 1 10
2 15
3 20


I want to display as

Contractor Circle Count
X 1 10
X 2 15
X 3 20
Y 1 10
Y 2 15
Y 3 20
Z 1 10
Z 2 15
Z 3 20

i want to display like this because when i do a filter , lets say 15 in the
COUNT column, i am not able to see the Contractor.
Is this possible ?

Thanks

 

[CarlosAntenna]

Right click on the pivot table, choose Table Options, check Merge Labels.
It still only shows the contractor name once, but it also shows when you
filter.

 

[student]

Thanks a LOT. That did my job.

Right click on the pivot table, choose Table Options, check Merge Labels.
It still only shows the contractor name once, but it also shows when you
filter.