3 Replies Latest reply on Aug 1, 2016 1:40 AM by Trần Ngọc Sơn

    Calculate % percent sales top n product in total sales group ( Category, all category)

    Trần Ngọc Sơn

      Hi everyone,


      I have a workbook about top n product. and now, i want to know top n product contribute Revenue in Total Revenue Category and All category.

      EX: I have top 10 product in Category ="Hàng Điện Tử", Sub-category ="Coppiers" with Revenue = "38,623,717".

      I calculated % percent revenue top n product in total revenue Sub-category.

      But I don't calculate total Revenue in Category " Hàng Điện Tử' includes all sub-category= { Accessories, Coppiers, Machines, Phones} and total revenue All category {hàng điện tử, hàng điện lạnh, nội thất}