3 Replies Latest reply on Jan 25, 2018 10:31 AM by Jim Dehner

    Mode calculation dilemma

    David Taylor

      There are plenty of wonderful community posts, like this one, on how to get a mode calculation working in Tableau. However, I wonder if anybody can help me find a solution here? I'd like a simple crosstab with the modes, but due to the technique I'm using, Tableau is giving me two rows for every category, for a total of six rows. I want only three rows.

       

      Here's what I have got, and I believe the calculations are correct:

      what i have got.JPG

       

      Here's what I want:

      what i want.JPG

       

      Does anybody have any suggestions? Thanks in advance!