3 Replies Latest reply on Feb 17, 2017 6:33 AM by Jim Dehner

    Percent Difference Field Is Summing - Work-around?

    Erik Wempa

      Hello.  I'm still learning the ropes of Tableau, and hope there's an easy fix to this...

       

      I have a user who wants to pull in data and display only the following on his worksheet:

       

      MEMBER COUNTS FOR JAN

      MEMBER COUNTS FOR DEC

      THE DIFFERENCE BETWEEN THE TWO

      THE PERCENT DIFFERENCE BETWEEN THE TWO

       

      I nailed all four calculated fields, but when I pull in my final field (% diff), Tableau automatically sums the value, giving me a value of 200% instead of the roughly 59% difference I'd like to see between my two monthly values.

       

      What's the quickest/easiest way to fix this?