I have a Hierachy Portfolio -> Project -> Location -> OrderID
My end user would like to have
Location1 Location2
M1 M2 M1 M2
Portfolio Project1 5 6 10 12
Project2 45 45 32 35
Project3 21 34 17 12
But since location is a child of a Project it looks like
Location1 Location2 Location1 Location2 Location1 Location2
M1 M2 M1 M2 M1 M2 M1 M2 M1 M2 M1 M2
Portfolio Project1 5 6 10 12
Project2 45 45 32 35
Project3 21 34 17 12
Is there a way to Sum /Aggregate/ group or whatever to achieve their wish
Than you
erwin