Combine Hierarchical Data

[hi.prashant]

I m building a model where I need data to be combined in various hierarchies. The output should be scalable and dynamic as input data may keep changing. Please see the attached file for example, I'm not sure whether I have put the question rightly. Any help is appreciated.

 

[mohamed ilyas]

hi

find the attached.. made with power query, you can enter en number of products, area, size.. finally refresh Green Table.

 

[hi.prashant]

Thanks Ilyas !