2 Replies Latest reply on Dec 20, 2016 3:28 AM by Simon Runc

    Dimension value fixed on customer level

    Tomasz Szajniuk

      Hi,

       

      I am trying to get a fixed value for a customer with a dimension value used in a first order. To be more specific I would like to see a city which was in a first customer order for all rows.

       

      I have:

      cities1.png

      What I want to have:

      cities2.png

       

      I tried:

      { FIXED [Customer name], [First order date]: [City]}

      but it doesn't work because an error appears that "City" has to be an aggregated field

       

      Any ideas how to do it?

       

      Best,

      Tomasz