9 Replies Latest reply on Oct 15, 2018 6:07 PM by mike cheng

# how do i find top 3 Order ID that sales the most

Hi

i build a calendar, how do i show the top 3 "Order ID" by sum(sales) in each calendar day

in other word, i just want to show top 3 in each day

mike

• ###### 1. Re: how do i find top 3 Order ID that sales the most

I used the Rank calculation on Sales and added to filter. See attached workbook if this is what you expecting.

• ###### 2. Re: how do i find top 3 Order ID that sales the most

hi

this is it! thanks but one more thing, if i add day in there it become this,

how can i show only one day number in there?

mike

• ###### 3. Re: how do i find top 3 Order ID that sales the most

how can i show only one day number in there?

What you exactly meant by this. I didn't understand ?

• ###### 4. Re: how do i find top 3 Order ID that sales the most

Let me know this is what you are looking for

• ###### 5. Re: how do i find top 3 Order ID that sales the most

i mean when i drag day in the text, it shows one day number for each order id, i just want one day number like calendar.

mike

• ###### 6. Re: how do i find top 3 Order ID that sales the most

Still not clear.Top 3 order id for each week and month can fall under same year or different year. See below screenshot.If you look at January/Week1/Monday, there are two dates associated with Top 3 order ids as Monday falls on different day in 2017 and 2018. Which day number you want to display ?

• ###### 7. Re: how do i find top 3 Order ID that sales the most

hi ombir

thanks for taking time for me

i add the year part in the view,

i dont want it to show day number for each order id in each calendar day space

i want to show only "one" day number and up to "three" order id in each calendar day space

• ###### 8. Re: how do i find top 3 Order ID that sales the most

Is this what you want. If yes, then please mark this answer correct so that it will also help others.

• ###### 9. Re: how do i find top 3 Order ID that sales the most

yes this is it, thank you so much~~