How do you determine the rank of a single store based on sales, I have tried the method shown here
but using the filter it keeps the rank at 1 no matter what restaurant I select.
could someone point me in the right direction.
1.Create a calc field RestaurantLookup
2.Drag it to the filter shelf.
Then you should be able to pick any restaurant and see its true rank.
I used Index() to get the ranking and edited the calculation to compute using Customer Name. I then added the Customer Name to the Pages shelf so you can select any Customer to get their ranking by Sales.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...