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

    Dimension value fixed on customer level

    Tomasz Szajniuk



      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:


      What I want to have:



      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?