3 Replies Latest reply on Aug 24, 2016 12:40 PM by Tom W

    Conditional grand total

    Samyukta Katha

      Hello,

       

      I am trying to create a conditional grand total in Tableau.

      My tableau workbook has power pivot as data source. I am trying to see the grand total based on two dimensions.

      If X > Y , then include in the grand total , if not ignore.

      Also I am trying to display this as a row total only for dimension X only. Is there a way to do this in tableau. Or Should I add it as a calc field in power pivot.

       

      Thanks a lot.