2 Replies Latest reply on Dec 12, 2016 12:32 AM by Alec Chen

    % to Total of Others in Top N not computing correctly...

    Alec Chen

      I'm trying to show Top N product designs versus others (from this tutorial: Showing a Nested Top N with "Other" in Tableau - The Information Lab) with a calculated field showing % to total within a category. Everything is working correctly, except the % to Total for the "Others" is incorrect. The calculation is based on the "Design" instead of the "Design/Other" (calculated field that determines the 'other' group).

       

      As you can see, the last column is the Other column, but the % to total is 1% which is obviously wrong.

       

       

       

      I've seen a couple of similar threads, but haven't been able to find any that addresses this specific question. Any help would be greatly appreciated!