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)

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}

• ###### 1. Re: Calculate % percent sales top n product in total sales group ( Category, all category)

Hi Tran

Let me know if is that you need.

Bests

4 of 4 people found this helpful
• ###### 2. Re: Calculate % percent sales top n product in total sales group ( Category, all category)

Hi. I want to calcution field % Revenue top 10 product / Category in this case.

EX: Revenue top 10 product in Category "Hàng điện tử" and Sub-category "Copiers" ="38,623,717" .  Total revenue  in Category "Hàng điện tử"  ="2,170,388,431"

% Revenue top 10 product / Category = 38,623,717/2,170,388,431 . How I can calculated in Tableau?

• ###### 3. Re: Calculate % percent sales top n product in total sales group ( Category, all category)

This case is difiicult to do, isn't it?