8 Replies Latest reply on Sep 16, 2019 8:10 AM by Don Wise

    Help.....Subtotal not coming out correctly.

    Edmond Lee

      Hi Everyone,

      I really need help with the following report. See screenshot and attachment. I have 4 columns named C&D Avg, Production Avg, RVD Avg & Transition Avg. Each of these columns is made up of combination of the column A, B, C, & D.

      For example, column C&D Avg calculation is:

      IF ATTR([Phase]) = 'C&D'

      THEN

      AVG([B] + [C] +[D]) / 3

      END

       

      Column RVD Avg calculation would be:

      IF ATTR([Phase]) = 'RVD'

      THEN AVG([A] + [B] + [C]) / 3

      END

       

      Sum of All 4 Phases calculation is:

      [C&D Avg]  + [RVD Avg] + [Production Avg] + [Transition Avg]

       

      As you can see on the screenshot, the Total & Grand Total aren't showing any value on these 5 columns. Do you know why Tableau isn't pulling any value on the Total/Grand Total row?

      How can i fix this?

       

      Thank you.

      TableauScreenshot.png