I am having dimension tables item (item_id,name,category) Store(store_id,location,region,city) Date(date_id,day,month,quarter) customer(customer_id,name,address,member_card) fact tables Sales(item_id,store_id,date_id,customer_id,unit_sold,cost) My question is if I want to find average sales of a loc...