I have this data which have Drinks, (meals, side dish, main Dish.)
Now I want to calculate an average of Drinks with (Rest)[meals, side dish, main dish) . How do I do it? I tried doing straight forward by right clicking and calculating the average, but its not what I wanted.
I have attached the screenshot too. The Screenshot here shown is the Time and total in columns and Product Categorie in rows. The 1st one is Drinks and below it are the REST . I want to calculate the average of Drinks and Rest.