Forum Discussion

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

Hierarchy in Table.

Hello @all,   Entity Table: Role   Name   Status   Segment Associate Manager   Imtiyaz   Live_In Admin   Institutional Director   Ryan   Live/In Dissolution   Institutio...
Need Help
MintuBaruah's avatar
MintuBaruah
Icon for Helper III rankHelper III
4 years ago

Hi smpa01 

 

Thank you for the reply. 

This solution is working but there is one problem I have to show this in a Matrix visualization and the Grand total is showing the wrong values (Please refer to Screenshot 1).

 

Screenshot 1:

 

 

 

 

 

 

Is there any solution to this issue as there is no option to disable this?

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

MintuBaruah  what is your desired output?

  • MintuBaruah's avatar
    MintuBaruah
    Icon for Helper III rankHelper III
    4 years ago

    smpa01 , I just noticed in the Screenshot above the Director's total is incorrect but it is showing the correct values in my data.

     

    Anyways, Grand total should also reflect the total of the "Director". As that is the total count.

    In this case, the Director should have a total as:

    Corporation: 1, Institutional: 3, Private: 1

    Same total for Grand total

     

    Thanks.

    • smpa01's avatar
      smpa01
      Icon for Community Champion rankCommunity Champion
      4 years ago

      MintuBaruah  can you please confirm if you desire to see 1 in the highlighted section? Please explictly tell me what is your final desired output either through an expliict screenshot or table

       

       

      • MintuBaruah's avatar
        MintuBaruah
        Icon for Helper III rankHelper III
        4 years ago

        smpa01 , yes. 

        For Director- Corporation: 1, Institutional: 3, Private: 1

        For Total- Corporation: 1, Institutional: 3, Private: 1

         

        Thanks.