2 Replies Latest reply on Mar 4, 2017 5:13 AM by Jim Dehner

    How can i use dimension names i have created in a calculated field?

    Vikram Raju Vegesna

      I have the following data:

      Row ID                     Sales                  Profit

         

      1261.54-213.25
      4910123.02457.81
      50244.5746.71
      804965.75951198.97
      85394.2730.94
      86146.694.43
      9793.54-54.04
      98905.08127.70
      1032781.82-695.26
      107228.41-226.36
      127196.85-166.85
      128124.56-14.33
      134716.84134.72
      1351474.33114.46
      14980.61-4.72
      1601815.49782.91
      161248.2693.80
      1754462.23440.72
      176663.784-481.04

       

       

       

      Now to see the average sales ad profit for row numbers less than 50 and row numbers above 50 I have created a calculated field called Age

      It is defined as If row ID<50 then Pre else Post and when I create the view I get this:

       

      Is there any way I can get another column in the same view that gives me difference each row of Age_Pre and Age _Post.

      i.e. 1757 - 1793

             170  -  191