Dear experts.
I have the following data:
Product.............Store Location.............Price
Bottled Water.............London.............2.00
Bottled Water.............Birmingham.............1.50
Bottled Water.............Manchester.............1.00
Candy Bar.............London.............3.00
In BEx query, I need to display the average price of Products without the Store Location. When I execute the query, only the total is displayed as shown below.
Product.............Average Price
Bottled Water.............4.50
Candy Bar.............3.00
How can I change the price result to show the average price i.e. $1.50?
Thanks.