Filter one side of pivot table

[ndeeleysww]

Hi all,

Think this is not achievable, but I need to filter just one side of a pivot table.

I have a count of equipment by work group. This count never changes as its the total of the equipment. Joined to that is a count of work orders on that equipment, filerable by cost centre. I can create the table, but when I add in the filter it of course filters the whole table, and reduces the equipment count accordingly.

Any ideas how I can over come this one?

Thanks all

Neil

[ndeeleysww]

Thanks Sunny- that's worked a treat.

[sunny_talwar]

Awesome