Matrix Total

Question

Hi,&nbsp;I have a matrix with values but some of my totals don't add up. My value is a distictcount on app_id which is a text. I also have a 1 to 1 join app ID To comp ID. I use the comp table for the row (house_type)&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; House.&nbsp; Flat.&nbsp; &nbsp;Bungalow&nbsp;Rem.&nbsp; 20.&nbsp; &nbsp; &nbsp; &nbsp; 5.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1Conv. 30.&nbsp; &nbsp; &nbsp; &nbsp; 10.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3FA.&nbsp; &nbsp; &nbsp; 12.&nbsp; &nbsp; &nbsp; &nbsp; 7.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2Total&nbsp; 60.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;21.&nbsp; &nbsp; &nbsp; &nbsp;6&nbsp;Any idea how to get this to Total right please?

idrissshatila · Answer

Hello&nbsp;M_SBS_6&nbsp;,
&nbsp;
it depends on the measure you're using. Please insert your measure.

m_sbs_6 · Answer

I'm just dragging app_id into the value then on the down arrow, I am selecting Count (distinct)

idrissshatila · Answer

Hello&nbsp;M_SBS_6&nbsp;,
&nbsp;
try creating this measure:
&nbsp;
measure = countrows( values(YourColumnName))

m_sbs_6 · Answer

Thanks for the suggestion but that gives me the same output as my distinct count.&nbsp;

Forum Discussion

Matrix Total

4 Replies

Related content

Totals in Matrix

Matrix Totals Incorrect

Formatting grand total in matrix

Matrix Row Totals

Matrix Adding total from previous Group