Remove rows from Pivot Table

[ndeeleysww]

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

[ndeeleysww · Accepted solution]

Sorry - dim of me! I used the match function to hide the rows:

if(match(CostHeader, 'LABOUR', 'EQUIPMENT'), CostHeader)

[sunny_talwar]

I am guessing that cost header would be your dimension and if that's true you can use calculated dimension:

If(Match([cost header], 'Labour', 'Equipment'), [cost header]) and then you can Suppress the Null Values for this dimension.

Best,

Sunny

[sunny_talwar]

Is the issue resolved then?

[ndeeleysww]

Yes - finally figured that one out! Thanks for your reply.

[sunny_talwar]

No Problem! I am glad that you got what you needed.

Best,

Sunny