4 Replies Latest reply on Nov 25, 2014 1:56 AM by Ram Asokan

    creating a measure/dimension out of a calculated field

    Ram Asokan

      Hi folks,

       

      Just wondering if it is possible to create a measure/dimension derived from a calculated field?

       

      Kind off in quandary right now - unable to find the best feasible way to get around this issue.

       

      Problem statement is something like this:

       

      Two columns in the data table, 1 is the the type of service field - which has 3 different distinct values to it and a revenue field which is obviously the revenue garnered from the services provided.

       

      What I would like to do is for example in a IF statement:

      if [ServiceType_Column1  = 'Service A']

      then sum(Revenue) as Revenue_A

      elseif [ServiceType_Column2 = 'Service B']

      then sum(Revenue) as Revenue_B

      else [ServiceType_Column3  = 'Service C']

      sum(Revenue) as Revenue_C

       

      then from the calculated field have 3 different measures - Revenue A, Revenue B, and Revenue C.

       

      Is this possible in tableau? As of now - I highly doubt it, but just thought I ask this question here to see if you 'gurus' might have an idea or a workaround maybe?

       

      Thanks heaps in advance

       

      Best Regards,

      R