Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Matrix Table How To Get Only One Sum #help

Hi

I want to create a matrix table that looks like the one below, with only one grand total for the entire row.

 


But I couldn't achieve the desired appearance for my matrix table. How can I change it to have only one grand total?



Settings

If I turn off subtotals, the grand total doesn't sum up

 

 

 




Need Help
  • zenisekd's avatar
    zenisekd
    2 years ago

    Anonymous here is your answer. You can set for columns whether they should subtotal. 

    Kudos and mark as solution of this post appreciated 🙂

3 Replies

  • zenisekd's avatar
    zenisekd
    Icon for Super User rankSuper User
    2 years ago

    Anonymous 
    There must be something wrong with the fields that you are using in the visual.
    This i how matrix looks like by default:

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      I'm using multiple columns for aesthetic reasons. However, when I use only one column, it works fine



      If I only use one column, it's working okay.

       



       

  • zenisekd's avatar
    zenisekd
    Icon for Super User rankSuper User
    2 years ago

    Anonymous here is your answer. You can set for columns whether they should subtotal. 

    Kudos and mark as solution of this post appreciated 🙂