Total by Product & Subgroup

[Aravind_Kumar]

Material	RM Category	Cost	% of Cost
SKU1	Fuel	1000	38%
	Gas	250	9%
	Transport	500	19%
	Direct	700	26%
	Indirect	200	8%
	Total Cost	2650	100%
SKU2	Fuel	750	25%
	Gas	850	28%
	Transport	900	30%
	Direct	200	7%
	Indirect	300	10%
	Total Cost	3000	100%

Hello Guys : Can you pls provide some guidance to do this % of Cost Column (4) which is the total within product and category of that product ?

[Icey]

Hi @Aravind_Kumar ,

You can try what @amitchandak mentioned, it will give you the expected result. And here is the test result:

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Aravind_Kumar ,  Try a measure like

divide(Sum(Table[Cost]),calculate(Sum(Table[Cost]), allexcept(Table, Table[SKU])))

or

divide(Sum(Table[Cost]),calculate(Sum(Table[Cost]), filter(allselected(Table), Table[SKU] = max(Table[SKU]))))