2 Replies Latest reply on Jul 31, 2018 8:01 AM by Bill W

    Circumvent around Grand Totals and Subtotal Rows

    Bill W

      Morning Tableau Friends,

       

      I attempting to try to figure out a way to have my table calc not factor in my SubTotal or Grand Total Rows within the view.

       

      I've set up a Table calculation in order to identify when values have changed per the previous month:

      [Value Delta (Color Filter)]

      IF SUM([Value]) > LOOKUP(SUM([Value]), -1) THEN 'Pos Change'

      ELSEIF SUM([Value]) < LOOKUP(SUM([Value]), -1) THEN 'Neg Change'

      ELSE 'Same'

      END

       

      However, unfortunately this also impacts the Sub-Total and Grand Total lines as well.

       

      Is there a way to have it "skip" over these rows and not change the color of the those values? Maybe using the set or something?

       

      Thanks for your time.

       

      -Bill