Forum Discussion

tuncay's avatar
tuncay
Icon for Helper III rankHelper III
4 years ago

Create hierarchy in a column

I have a column in a table, where I've got IDs of different units. I can use these IDs in my slicer on the first page of my report. The problem is that in the same column I have totaled up IDs (this ID is the division). On the first page, I want to show the totaled up IDs (divisions) , but on the second I want to show the IDs which belong to that division. So I can filter on the page, that it shows only certain IDs. But I need to create a relationship of the other IDs to that ID, like an hierarchy..

 

 

Can somebody help?

Need Help

1 Reply

  • yakamoz007's avatar
    yakamoz007
    Icon for Helper I rankHelper I
    4 years ago

    Hi

    you have to add a column in your table where you say this ID belongs to this Divison/Group. I don't know what this picture shows. Is this your fact table with ID or is it an normal attribute table?

    You can also create an seperate mapping table with ID and Group. This table is the table where you can see to which groups your ID's are belonging.Then you can join this with your fact table where your key data is.

     

    I hope I undersand your questions right.