Forum Discussion

VBAmazing's avatar
VBAmazing
Frequent Visitor
1 year ago
Solved

Subtotal in Matrix Row not Appearing

Hello Forum,   What appears to be a straightforward ask not working as expected at all.   Requirement: Get Subtotals for First row of a Matrix I have a Matrix view with all of my analysis dimen...
  • audreygerred's avatar
    1 year ago

    Hi! Here is an example and it has the per row subtotal on and on on every row:

    If I turn off all of them except the first one, it removes all of them and just leaves a total at the bottom (not in screenshot, but it is there).

     

    What I suggest is turn all the subtotals back on, then, start with the bottom row in the drop down and start turning them off to see if that is what you want to accomplish. My guess is you will need the second one to be on. See, here, I have it on for Dept and Country.... and this shows me subtotal for Dept which would be Customer in your example. Having Customer and City on in your example should achieve your goal, but I always just start from the bottom of the drop down and work my way up as I turn off to see if it is dispalying as I want.