2 Replies Latest reply on Apr 8, 2016 5:23 PM by Esther Aller

# Started from the bottom now we're here

Inspired by a recent Drake song, I decided to make a calculation that interprets "started from the bottom now we're here".

Using the lovely sample data from the infamous Superstore, I decided my view needed to include customers because Drake tells us "now my whole team here". What to measure though? Sales! Because we all know how important the moolah is. More money is more important, so the customers with the most sales must be at the top, naturally. And behold:

Now we have a baseline. We need to start at the bottom and get "here". Running total solves half of the puzzle: we start at the top and at every row we are "here". But how do we start at the bottom?

Never fear! We can use the advanced table settings to start at the bottom:

1. Right-click [Sales] and select Edit Table Calculation...
2. In the Table Calculation dialog, in the Running along dropdown menu, select Advanced...
3. In the Advanced menu (I promise this is the last menu), we're going to change how the table calculation is sorted:
1. Select the Field radio button under Sort
2. In the dropdown menus choose Sales Sum
3. (this is the critical step) select Ascending
4. Hit OK twice to close all those dialog boxes

Viola! We started at the bottom with the customer with lowest sales and now every row we have the running total of sales for that row here. The metaphor holds, trust me

You can also check out my finished view on Tableau Public!

Anyone else translate a song into a viz?

• ###### 1. Re: Started from the bottom now we're here

This is the best! You can post it in our TabWiki to make it easier to find!

• ###### 2. Re: Started from the bottom now we're here

Thanks Diego! I will post it on TabWiki