This content has been marked as final. Show 5 replies
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.