Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sorry - dim of me! I used the match function to hide the rows:
if(match(CostHeader, 'LABOUR', 'EQUIPMENT'), CostHeader)
Sorry - dim of me! I used the match function to hide the rows:
if(match(CostHeader, 'LABOUR', 'EQUIPMENT'), CostHeader)
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
Is the issue resolved then?
Yes - finally figured that one out! Thanks for your reply.
No Problem! I am glad that you got what you needed.
Best,
Sunny