Calculate Percentages

[eheaton]

When calculating percent in a metrixs table a percentage is calculated for each column. See example below.   How can the second and third percentage (blue type header)columns be removed or not calculated?

Year		Units Damaged	% Units Damaged	Units Undamaged	% Units Undamaged	Unit Total	% Total Units
2016	Location A	3	10.71%	25	89.29%	28	100.00%
	Location B	5	11.90%	37	88.10%	42	100.00%
	Location C	2	3.51%	55	96.49%	57	100.00%
2016 Total	10	7.87%	117	92.13%	127	100.00%
2017	Location A	4	7.84%	47	92.16%	51	100.00%
	Location B	7	9.59%	66	90.41%	73	100.00%
	Location C	8	18.18%	36	81.82%	44	100.00%
2017 Total	19	11.31%	149	88.69%	168	100.00%

[Greg_Deckler]

Remove those columns from your Columns area in your matrix visualization?

[eheaton]

Not sure how to remove the columns from the metrix visualization as I do want to retain the % Units Damaged column.  Below is what I would like the finished report to look like.

Year		Units Damaged	% Units Damaged	Units Undamaged	Unit Total
2016	Location A	3	10.71%	25	28
	Location B	5	11.90%	37	42
	Location C	2	3.51%	55	57
	2016 Total	10	7.87%	117	127
2017	Location A	4	7.84%	47	51
	Location B	7	9.59%	66	73
	Location C	8	18.18%	36	44
	2017 Total	19	11.31%	149	168

[v-jiascu-msft]

Hi, @eheaton

The column headers here ought to be in one column in the source table. There could be two solutions.

1. Remove the columns you want to delete from the source table.

2. Use filter to hide the columns. In my example, it only shows two color I want.

[v-jiascu-msft]

@eheaton

Hi,

Did this work? Or something else I can do to help?