Forum Discussion
Merge region data
Hello! First, sorry for my English) I wil use pictures. I have a data by cities and regions, but they are together: I want to see the cities data added into the corresponding region rows. For ex...
Thanks for the answer. I read it fluently and I have a question. Analogy with parents is good. If we speak in terms of sales, in my situation children and their parents sell both. And i have the situation:
(Oops! At the screen I should write Bill: 10+1+4+2+1)
Will I reach this goal using parent-child hierarchies?
If yes, I'll study this in more detail.
Yes, you are correct. The aggregation for parent level will include themselves. If the parent level has fact data, it will appear along with child members as well. Like the last image in that link:
You should build the Parent-Child hierarchy for your scenario.
Regards,