Totals

[kev6brown]

I have the following table

Make	Model	Price	Sales		Total
ABC	1	500	2		15
ABC	2	2000	3		15
ABC	3	3000	4		15
ABC	4	2500	6		15
DEF	1	1000	6		2
DEF	2	300	3		2
DEF	3	5000	5		2
DEF	4	350	8		2

I'm trying to calculate the "Total" Column which is the total sales of each Make, what do i need in my measure?

Thanks

Kev

[Kushal_Chawda]

@kev6brown  try below

=sum(total <Make> Sales)