Dynamically select rows

[ManuelRodrigues]

Hi Team,

Could i pls ask if you can help, I am trying to select rows and creating separate data feeds to pivot an analysis from. I have tried to use the multi row and filter tools to extract all the rows e.g. are related to the Profit and loss or balance sheet to separate areas but i am struggling and was wondering if you can assist? Example attached

[atcodedog05]

Hi @ManuelRodrigues 

Here is one way of doing it.

Workflow:

Hope this helps : )

[ManuelRodrigues]

thanks @atcodedog05 i,ve tried to replicate this on the data set attached but i am struggling. to clraify all the areas highlighted in green needs to be filtered out by the row labels highlighted in green?