2 Replies Latest reply on Jul 24, 2016 7:57 AM by Béatrice LORIOT

    Sum one item of the dimension only

    Béatrice LORIOT

      Hi all,


      I am sure this is a stupid question but can't find the solution myself ..


      My dimension is user type and my measure is visits, as follows :

      User type               Visits

      New visitor              2000

      Returning visitor     2500


      I want to extract New visitor visits only (not filter) and get a measure for new visitors visits only.

      I tried

      if ATTR( [User Type] )='new visitor' then sum ([Visits]) END, calculation is valid but but it s not working and return "null value"


      Thanks for your help