Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Subtotals in Table for specific rows

Hi all,

 

I want to calcualte subtotals in a table for specific rows.

 

 

In my example, I want to have an extra subtotal row if there are same entries for on Col B (basically a group by)

Is this possible?

 

Best

Waldemar

Need Help

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Anonymous,

     

    It is available to add SubTotal rows in a Matrix visual. Add [ColB] to "Rows" section of Matirx and turn on "Row Subtotals" option.

     

    Regards,

    Yuliana Gu

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks for your answer. That's not exactly what I want to display.

       

      - I just want to see subtotals only if there is more than 1 occurance in the group.

      - I need to see the other attributes as well (Col A, Col B and more)

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi Anonymous,

         

        That case, it is not possible to achieve such a requirement now.

         

        Regards,

        Yuliana Gu