5 Replies Latest reply on Feb 17, 2016 1:40 AM by Sabine Honer

    Percentage calculation didn't work because of divisor ( wrong aggregation level)

    Sabine Honer

      Hi All,

       

      unfortunately I didn't get a calculation to work in Tableau :-(

      May data looks like that

       

       

      Category 1Category 2Value 1Value 2
      Ax47329
      Ax31442
      Ax33427
      Ax14233
      Ax49518
      Ax43641
      Ax27422
      Ax25942
      Ay16722
      Ay10810
      Ay44537
      Ay24541
      Ay44622
      Ay32931
      Bx20833

       

      I created a calculation in Tableau saying ([Value 1]-[Value 2])/[Value 1] for both categories.

      Output works for Category 1 = B as I have only one value.

      I also tried to use  (sum([Value 1])-sum([Value 2]))/sum([Value 1] ) => but for Tableau calculation isn't valid.

       

      I am thankful for any kind of hints.

      If you have questions, please let me know.

       

      Best regards

      Sabine