1 of 1 people found this helpful
As per my understanding i worked around ur problem on Multiple rankings showing with Measure and dimension.
find the below attached tableau work book.
Thank you, Bhujan, for trying to help me.
Your list is in some degree useful for my purpose, but not entirely what I am trying to do (and want).
Hopefully my new attachment (suffix v2) is a better explanation of what I hope is possible to do in Tableau 7.
If not, I will look more carefully at your solutions. I am still relatively new in Tableau, and have not used "sets" yet, which is part of your solution.
I have tried to "swap" your list by moving product category to the column shelf, but cannot figure out how to make it work, and wonder if it is possible. I have a feeling it is only possible to mix text and value columns (regarding multiple rankings) on the row shelf.
I prefer having the product category on the column shelf, because
- the text fits easier on the same screen (no scrolling)
- the main view on the same dashboard (regarding my task at hand) needs as much as possible of "horizontal space"; therefore it is better having the top n lists above or under rather than beside the main view
- it simply looks more orderly (for ranking that is) and therefore easier to understand
If what I want is not possible, I will use a vertical list (similar to yours) with category on the row shelf. This I can also do with the INDEX() function as seen in attached workbook. I will use INDEX() for my task, because I am not familiar with sets yet.
See the attached for two versions (and one variant) of this, done in Tableau v8:
- One version uses a multiple axis crosstab so instead of using Measure Names/Measure Values, it's using mark labels (which can be text/date/numeric/wingdings/whatever). This solution is also possible in v7.
- Another version use a duplicated data source to get us multiple columns, then takes advantage of v8's feature to have multiple pills on the Text/Label Shelf. I prepared a couple variations of this showing different formatting settings.
None of these are ideal in that the column widths have to be the same for the Customer and Sales columns, when it's more likely we'd want a wider Customer column for longer names.
I mark this as a correct answer, because (1) this in some sense is the correct answer, and (2) I am impressed that you could trick Tableau to go this far. That said, this is too complicated and limited to be a satisfactory solution.