1 2 Previous Next 18 Replies Latest reply on Aug 13, 2019 2:40 PM by Subodh Gupta Go to original post
• ###### 15. Re: Ranking Top Customer Sales Over Three Years

Subodh would you mind sharing your tableau workbook whenever you have a moment with the second answers attached?

• ###### 16. Re: Ranking Top Customer Sales Over Three Years

John -- out of curiosity if I have a set that is only pulling in the top 10 sales will this work the same way? For some reason I'm having a bit of trouble getting the order of your table calculation pictured...

• ###### 17. Re: Ranking Top Customer Sales Over Three Years

Chase,

I could do it today evening.

Subodh

• ###### 18. Re: Ranking Top Customer Sales Over Three Years

How are you determining top 10?

Also, I've attached a workbook that is based on Subodh's approach.

Here are the steps:

Step One:  Drag Cust Name to columns

Step Two: Drag Year of Inv Date to Dimensions

Step Three: Drag Year of Inv Date to columns

Step Four:  Drag Sales to Rows (it should auto aggregate to SUM(Sales)

Step Five:  Drag another copy of Sales from measures Sales to Text on the Marks card

Step Six:  Drag another copy of Year of Inv Date to Color

Step Seven:  Right Click on Cust Name on the Columns Shelf->Sort-> and set up like this:

Step Eight:  Right-Click on Year of Inv Date on the Columns Shelf->Sort-> and set up like this:

Now it should look just like the last image Sobodh posted.

• ###### 19. Re: Ranking Top Customer Sales Over Three Years

Not sure if you still need the workbook, but there it is.

1 2 Previous Next