11 Replies Latest reply: May 12, 2015 8:55 AM by Sunny Talwar RSS

    Filter one side of pivot table

    Neil Deeley

      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