Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks Sunny- that's worked a treat.
Awesome