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