Add a total column to a matrix using different field than what's in the Values field

[MEFOX]

I need to add a total column to a matrix. This total column field will be in addition to TotalAccounts field in the Values field pictured below. Is there a method to do this in a matrix visual?

[TheoC]

@MEFOX Can you paste an example of the Total Values you are wanting to be included?  I may not be understanding the question correctly, however, if I am, you should be able to create a Calculated Column or Measure and drag this into the Values pane.

[AlexisOlson]

Not really, at least not cleanly. Generally, you can't have total rows for measures that aren't included in the matrix.

[MEFOX]

Do you have a suggestion as to how to accomplish this? Is there another visual that might work inplace of the matrix? 

[AlexisOlson · Accepted solution]

There are some hacky workarounds like this or creating another matrix for the second total row (partially hidden behind the existing one). I don't know of any other visuals to recommend.