4 Replies Latest reply on Oct 4, 2017 10:34 AM by Lauren Mottley

    crosstab creates two columns for one value

    Lauren Mottley

      I'm having an issue where I have a dimension that is getting duplicated and shown twice when I pull in other dimensions in a crosstab (and only certain ones).  I can't figure this out, because when I view the data it shows distinct values (not duplicated ones) and when I query the data live in SQL (outside of Tableau) I'm not seeing this duplication either.  Furthermore, this is happen even more across other crosstabs I've built when I create an extract versus connect Live. 

      The dimension holding the values "control" and "test" only has those two values... and I don't know why Tableau is creating three (3) values.  Any help is much appreciated!