Average of Ratios

[MallikarjunaG]

Hi All,

Could you please help calculate average of ratios , please find the sample data as below

Product Group	Brand	2024 Jan			2024 Feb
		Net Price	Volume	Ratio	Net Price	Volume	Ratio
Prod1	Brand1	100	10	10	200	10	20
Prod1	Brand2	200	40	5	500	40	12.5
Prod1	Brand3	300	50	6	600	50	12

Accepted result

Product Group	Brand	Avg
Prod1	Brand1	15
Prod1	Brand2	8.75
Prod1	Brand3	9

[robert_mika]

it would depends on your data structure, and how the values in table are calculated(front or back) usually will be something lie

avg(aggr(sum(ratio),Product1))

[Chanty4u]

Try this 

Avg(Aggr(Avg(Ratio), [Product Group], Brand, Month))

[Nagaraju_KCS]

Use this 

avg(aggr(sum(ratio),Product, MonthYear))