Group by keys

[agarwal16]

Key	EAP Number	Description	Flag	CDM_Unit_Price	Key1	WeightedAverage	CPT Code
						48.815326373101
RC112	112	AV	RC	217	RC|96372	0.064323455088445	96372
ROPH112	112	AB	CA	124	ROPH96372	17.043596508616	96372
RUH112	112	CD	CA	123.94	RUH96372	36.381438588074	96372
RC23	23	BG	RC	217	RC|96372	48.333502366464	96372
ROPH23	23	BH	CA	124	ROPH96372	22.828434560022	96372
RUH23	23	GH	CA	123.94	RUH96372	50.019778552919	96372

Here we have calculated weighted Average based on Key.

then again we have to show the weigted average grouped by Key1

output should be like: Only a single row item based on Key1.

how to do please suggest.

Key	EAP Number	Description	Flag	CDM_Unit_Price	Key1	WeightedAverage	CPT Code
						48.815326373101
RC112	112	AV	RC	217	RC|96372	0.064323455088445	96372
ROPH112	112	AB	CA	124	ROPH96372	17.043596508616	96372
RUH112	112	CD	CA	123.94	RUH96372	36.381438588074	96372

[BrunPierre]

=ONLY(AGGR(MIN(WeightedAverage),Key1))

[BrunPierre · Accepted solution]

@agarwal16 Did it solve your problem? please mark accordingly.