5 Replies Latest reply: Apr 14, 2015 6:25 AM by Sunny Talwar RSS

    Remove rows from Pivot Table

    Neil Deeley

      Hi all,

       

      I'm creating a pivot table and need to remove some rows from the table. For example, in my data I have many types of cost header - such as Labour, Equipment, Materials. If I want to show just the Labour and Equipment, how do I not show the Materials rows, or any rows underneath if I add to the pivot?

       

      I don't want to remove the data I don't need on load as I'd like to reference it later in the app, but if it is possible to hide this data with an expression then that would be a great help.

       

      Thanks

      Neil