Aggregating measures

[#1]

Hi Community,

I'm trying to build the following column in the below table in QV. I need the max Sales person sales amount for the each row.

Sales_Person	Date	sum(Sales)	Max SP Sales (Requirement)
Joy	1/1/2016	$50.00	150
Joy	1/2/2016	$150.00	150
Joy	1/3/2016	$100.00	100
Tim	1/1/2016	$30.00	45
Tim	1/2/2016	$45.00	45

I was trying to use the following expression, but to no avail. 

max(total <Sales_Person> aggr(sum(Sales), Sales_Person))

Please provide your guidance. Thanks V.

[sunny_talwar · Accepted solution]

Try this:

Max(total <Sales_Person> aggr(sum(Sales), Sales_Person, Date))

[#3]

Thanks Sunny. Much appreciated