Forum Discussion

Han_Solo's avatar
Han_Solo
Regular Visitor
1 year ago
Solved

Subtotal to Matrix Visual not working.

Hi, hope this is an easy fix that I have overlooked. 

I have a matrix visual as follows: 

The Issue: I am trying to create a total just for the "Count" column (which is actually under Values, so I have to enable "Row Subtotals". However, this gives me totals for all of the values which I dont want. 

When I enable Per Row Level, it allows me to select 2 (out of four) measures in the Rows. Selecting either does not help. 

 

I thought the problem was the range measure which might have been messing up the ability to select specific totals, however i tried with a differnt measure in the Rows and did the same thing.  Any help would be appreciated.  

 

 

2 Replies