I'll check out the millions of other comments on this to see if I can find one, but so far, everything I have read hasn't got me to where I need to go. I want to run several reports, but what I am trying to do for this specific case is to reconcile the differences between two Excel worksheets, and have an index that shows the total number of rows overall. I am going to break this down simply.
Let's pretend I need to get the total list of fruits from my vendors. I have one vender selling apples, oranges, and peaches (worksheet 1). I have another vendor selling apples, pears, and peaches. I put the two table side by side and I have two column - this I can do.
Apples, Apples
Oranges, Null
Peaches, Peaches
Null, Pears
Below is what I want, please don't suggest other things... this is to reconcile between two sheets and this is how I need it. If you don't know, please don't comment on stuff that doesn't help. Sorry, I just hate reading all of these millions of suggestions on indexing that miss the mark for everyone, and most of it is a waste of time because someone is offering something random instead of helping resolve the specific issue.
So, what I want to do is add an index so that the sheet I get looks like this
- Apples, Apples
- Oranges, Null
- Peaches, Peaches
- Null, Pears.
I have tried many of the suggestions, e.g. creating the index, making it discrete, setting it to a particular field, turning off aggregation, various ways of setting just about every setting from all of the other recommendations, and none have worked.
Thank you in advance.
@Christopher Griggs
It sounds like you are mostly there. You created the Index and set it to discrete. If you want it ordered alphabetically based on vendor 1's fruits, you can set the Index table calculation to sort Ascending from the minimum value. You could do a full outer join of the tables, but you can also use Relationships. To show all items from both tables, you need to put a measure from each table in the view. I put the Tableau generated count measure on the Details mark. To not show the headers, right click on the headers and select 'Hide Field Labels for Rows'.
[Edit, not in attachment] If you want one field with commas, select both fields, right click and select 'Combined Field'
James Emery
Tableau Forum Ambassador
Once a response addresses your problem, please click 'Select as Best' so future users can quickly find the answer.
