cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shihwenwu Frequent Visitor
Frequent Visitor

get top title of seller via measures

Hi,

 

 

Currently I have to rely on "sales by sku" to know which is the top n sellers by each month.

 

I would like to create a measure that shows the sku of top 1 seller (either by unit or by sales) and adding it to my "main dashboard", another measure column for 2nd best, and another for 3rd best and so on.

 

top_data_structure.PNGThe data structuretop_dashboard.PNGdashboard overviewtop_dashboard2.PNGselect Augest to check top sellers from "Sales by sku"top_dashboard3.PNGselect JuAuguesto check top sellers from ""Sales by sku

 

Any ideas how to achieve that?

 

Thanks~

 

 

2 REPLIES 2
edejes2
Advisor

Re: get top title of seller via measures

Hello @shihwenwu,

 

Try this,

Total Sales=SUM( Sales)

Total Cost= SUMX(Sales,units_order]* price)

Total Profit= Total sales- Total Costs

SKU Rank= RANKX(ALL( SKU),Total Profit, , Desc)

Top 5 Sku= IF (isfiltered(sku),IF (SKU Rank <=5, Total Profit, Blank() ),CALCULATE (total profit, TOPN (5, Values (SKU),total profit))

 

Regards!

ED

 

 

shihwenwu Frequent Visitor
Frequent Visitor

Re: get top title of seller via measures

Hi @edejes2

 

Thanks for replying.

 

But, the measure I'm looking for is returning the sku name of the product rather than number.

 

In the example dataset should looks like this:

 

monthunit ordersale1st sku2nd sku
7641015de
81582410dc

 

 

Sorry if I didn;t clearify myself.

 

Thanks~