How to sum all records when grouped by a primary dimension, but only show sum on last record of the grouped dimension...

[#1]

I am trying to get my expression in a strait table to look like the last column in the image below. Any ideas on how to do this with inter record functions?

Thanks.

Product	Production Location	Inventory Cases	Inventory Cases Sum Grouped By Production Location
12345	100	100
12345	100	150
12345	100	75	325
12345	200	30	30
12345	300	200
12345	300	180
12345	300	530
12345	300	400	1310

[#2]

Thanks Fernando. I think this would have worked as well, but I went with the NMiller's recommendation.

[#3]

Fernando,

Your solutions actually placed the value on the last row of the group for me. So this one works for me as well. Here is an example. Thanks.

SKU	Branch_Plant	Order_Num	=sum(Inventory_Lbs)	Sum(TOTAL <SKU, [Branch_Plant]> [Inventory_Lbs])	Sum(TOTAL <SKU, [Branch_Plant]> [Inventory_Lbs]) WITH TEXT COLOR FORMATTING if(below(Branch_Plant,1)=Branch_Plant,white(),black())	Aggr(Sum([Inventory_Lbs]), SKU, [Branch_Plant])
12345	708001	1	200,000	550,000	550,000	550,000
12345	708001	2	300,000	550,000	550,000	-
12345	708001	3	50,000	550,000	550,000	-
12345	708002	4	200,000	400,000	400,000	400,000
12345	708002	5	200,000	400,000	400,000	-
12345	708003	6	450,000	1,100,000	1,100,000	1,100,000
12345	708003	7	500,000	1,100,000	1,100,000	-
12345	708003	8	150,000	1,100,000	1,100,000	-
12345	708004	9	250,000	250,000	250,000	250,000
12345	708005	10	100,000	150,000	150,000	150,000
12345	708005	11	50,000	150,000	150,000	-

[#4]

Thank you for the answer. This can help me