Forum Discussion

AnatoliBagrov's avatar
AnatoliBagrov
New Member
9 years ago

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...
Need Help
Show and Tell
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

AnatoliBagrov

 

In this scenario, you have fact data on both region level and city level. You need to build a "parent-child hierarchy" for REGION-CITY so that you can aggregate region itself and its child level together. Please refer to blog below:

 

Parent-Child Hierarchies

 

Regards,

AnatoliBagrov's avatar
AnatoliBagrov
New Member
9 years ago

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.

 

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    9 years ago

    AnatoliBagrov

     

    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,