Dynamically select rows

Question

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

Example file.xlsx

ManuelRodrigues · Answer

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?

atcodedog05 · Answer

Hi @ManuelRodrigues

Here is one way of doing it.

Workflow:

Hope this helps : )

combine data.yxmd