2 Replies Latest reply: May 15, 2016 12:18 AM by Sunny Talwar RSS

    Calculate dimension

    Prasanta Kumar

      hi,

       

      I have a data set like below.

       

       

      CustomerCost1Cost2Revenue
      A1030100
      B2010200
      C3020300

       

       

      I want to create a calculated dimension for customers based on cost1 and cost2,

       

      i want only those customer in my calculated dimension, when sum(cost1)+sum(Cost2)>=50.

       

       

      thanks

      Prasanta