display count of specific stage against total of camp

[tangutoori]

i want the below format

	Current matrix report
	stage 1	stage 2	stage 3	stage 4	Count
camp1	5	1		8	14
camp2	1	1	1	1	4
camp3		2			2
camp4	1	2	3		6
camp5			2	4	6
	I want vaues of stage 3 against camp in report
	stage 3	Count
camp2	1	4
camp4	3	6
camp5	2	6

[rocky09]

You could simply ignore other stages in Matrix columns?

[tangutoori]

excludin other stages impacting the total count.

any way thanks for you though.

[rocky09]

I  see that you edited your Question. In the First version, there are blank included in the Stage3 (expecting result).

[tangutoori]

yes.. as there is no values for stage 3 i ahve removed those camps intentinally.

even if they display also no matters.

[rocky09 · Accepted solution]

You can do one thing.

After Placing data on to the matric table. You go to the Visual Filter secton, there under Stage 3,  select Is not blank.