1 Reply Latest reply on Feb 12, 2019 6:55 PM by Zhouyi Zhang

    Calculate the Average of one product with rest of the other product

    Fpl Nepal

      Hello Everyone.

      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.

      thank you