Bharat Guru
asked on
excel how to add group by average to bottom of the page
I have excel sheet where I want to group by Location at bottom of page
ProductID, Product, Location, price
1 Product1, NY , 10
2 Product2, NY , 20
3 Product3, NJ , 10
3 Product3, NJ , 20
3 Product3, NJ , 30
Out put should be
ProductID, Product, Location, price
1 Product1, NY , 10
2 Product2, NY , 20
3 Product3, NJ , 10
4 Product3, NJ , 20
5 Product3, NJ , 30
Average NY 15
Average NJ 20
Grand Average 18
ProductID, Product, Location, price
1 Product1, NY , 10
2 Product2, NY , 20
3 Product3, NJ , 10
3 Product3, NJ , 20
3 Product3, NJ , 30
Out put should be
ProductID, Product, Location, price
1 Product1, NY , 10
2 Product2, NY , 20
3 Product3, NJ , 10
4 Product3, NJ , 20
5 Product3, NJ , 30
Average NY 15
Average NJ 20
Grand Average 18
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER