4 Replies Latest reply on Apr 12, 2018 3:15 PM by Randolph Ralph

    Exclude Row Value from Subtotal

    Randolph Ralph

      I am attempting to exclude a value from being included in a subtotal. My sheet is calculating sales, revenue, and revenue per sale. There are two dimensions under row (Type and Category). I am attempting to not include a revenue per sale calculation where the Category is Other, and also exclude this category from the row subtotal. I have attached my Tableau workbook with a calculated field named Test-Revenue per Sale in which I have attempted to exclude the Other Category, but the Subtotal will not calculate and shows blank.

       

      Here is what I am attempting to do.

       

       

      Example.jpg