Forum Discussion

roytap's avatar
roytap
Icon for Helper I rankHelper I
8 years ago

Adding Subtotal to secondary row dimension in Matrix table

Hi,

 

I am currently developing a report for my user.

 

I have 2 issues here from the attached image as shown below:

 

 

1. The report is created by having Sales Rep and Product Group grouping under the Row as shown above. However, the Total/Subtotal is only able to show the Sales Rep Grouping level. Is there any way to show the Product Group subtotal as well i.e. AWC ....., Conventional, Mepilex Lite as well?

 

2. Is there any way that i could hide the detail of one of the Product Group i.e. Conventional but show the total/subtotal of this particular Product Group instead? This is only applicable if the first point is achievable in the first place. 

 

Thanks.

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI roytap,

     

    #1. Yes, it is possible.

     

    The easiest way is change group column order and drag users to bottom.(From 'Area-> Users-> Items'  to  'Area-> Items -> Users') 

     

    Otherwise you need to use measure to instead 'amount column' with some conditions to replace specific row level contents as custom summary data.

     

    #2. Please take a look at following link to know how to use measure to hide child level items.

    How to hide bars when drilling down in the same visualization?

     

    Regards,

    Xiaoxin Sheng

    • roytap's avatar
      roytap
      Icon for Helper I rankHelper I
      8 years ago

      Hi,

       

      No, changing the dimension from row to column for the sales rep is not an option as it will have an endless columns. i.e. no. of sales rep x no. of measures defined under the value and it will make the table looks extremely unbalanced.

       

      I am actually looking for a SubGrouping total which is currently not available in the Matrix. Subgrouping Total is a very common feature that is widely used in the past BI Tool such as crystal report and Cognos. The properties available in the Matrix table is simply too limited for this visualization and i do not see any alternative table visualization from the marketplace. 

       

      Is there any example of the measure to that you mentioned in your reply? It is quite difficult to visualize your reply without any example when you mentioned that we should be creating some measures to replace the current product grouping dimension. 

       

      Thanks. 

       

      Best Regards,

      Roy

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi roytap,

         

        Can you please share some sample data with same table structure to test and coding formula on it ?(one or two hundred records should be enough)

         

        Notice: do mask on sensitive data before sharing.

         

        Regards,

        Xiaoxin Sheng