3 Replies Latest reply on Jan 24, 2019 9:07 AM by Deepak Rai

    Using the Same Dimension for Division

    chris.leong
    chris.leong Jan 24, 2019 8:13 AM

      Hi,

       

      Tableau newbie here on version 10.5

      I have a dimension called CountType that has some cells called ProcessedBuyers and some cells called RawBuyers. I am trying to create a calculation to add a new column that would show the percentage when dividing ProcessedBuyers/RawBuyers.

      I tried the formula below but to no avail.

      SUM(IF [Counttype] = "ProcessedBuyers" THEN ZN([Volume]) END)/SUM(IF [Counttype] = "RawBuyers" THEN ZN([Volume]) END)

       

      Any help would be greatly appreciated.

      Thanks!