Don't show general total row

[Raul]

Hello community!

It's possible in a matrix visualization show only the total of a group but not the general total of the rows? That is, I have this visualization:

DWS		DW1	DW2	Total
GROUP		Qty	Qty	Qty
Group1
	Row1	10	30	40
	Row2	12	10	22
	Row3	5	12	17
	Total	27	52	79
Total		27	52	79

(Group Total and Total Row)

And I want this:

DWS		DW1	DW2	Total
GROUP		Qty	Qty	Qty
Group1
	Row1	10	30	40
	Row2	12	10	22
	Row3	5	12	17
Total		27	52	79

(Total Row)

Or this:

DWS		DW1	DW2	Total
GROUP		Qty	Qty	Qty
Group1
	Row1	10	30	40
	Row2	12	10	22
	Row3	5	12	17
	Total	27	52	79

(Group Total)

Thank you!

[PattemManohar]

@Raul Any luck with turning off "Sub-Totals" under "Format" pane of the matrix.

[Raul]

Hi @PattemManohar,

If I turning off "Subtotals", the result is this:

DWS		DW1	DW2	Total
GROUP		Qty	Qty	Qty
Group1
	Row1	10	30	40
	Row2	12	10	22
	Row3	5	12	17

It's not that I want.

Thanks for your answer.

[PattemManohar]

@Raul Ok !! Could you please provide the raw data for the expected output mentioned above.

[Raul]

Test FILE.

Thanks!

[PattemManohar]

Thanks @Raul But unfortunately I can't access any cloud drives, it will be great if you can post the sample data (Copiable format) here....

[Raul]

Like this?

NLine	DWS	GROUP	ROW	Qty
1	DW1	Group1	Row1	10
2	DW1	Group1	Row2	12
3	DW1	Group1	Row3	5
4	DW2	Group1	Row1	30
5	DW2	Group1	Row2	10
6	DW2	Group1	Row3	12

[PattemManohar · Accepted solution]

Thanks @Raul for providing the sample data as requested.

I hope you are looking for this.. You need to use "GROUP" and "ROW" properties under the Format pane of the Matrix.

 

[Raul]

Perfect @PattemManohar!

Your proposal is entirely correct. Thank you!!!!