Summing of values in matrix table

[dhanekula1996]

Hello all,

I am Trying to sum the values at Hierarchy (Product A = Material A +Material B+ Material C) where as (Material A = 10) which inturn is the summed value.( Material A= Element 1+ Element2+ Element3). Total is the sum of values across product A (Total = Area1 +Area2 +Area3+..).  How to show this calculation in Matrix Visualization.

Thanks for your help,

Shashi

Product\Location			Area1	Area2	Area3	Area4	Total
Product A			40	10	0	40	90
	MaterialA		10	0	0	10	20
		Element1	5	0	0	0	5
		ELement2	5	0	0	0	5
		Element3	0	0	0	10	10
	MaterialB		20	10	0	20	50
	MaterialC		10	0	0	10	20
Product B			30	30	10	0	70
	MaterialD		10	10	0	0	20
	MaterialE		20	20	10	0	50

[lbendlin]

That should be standard matrix functionality. You get the level specific row totals and grand totals for free.