2 Replies Latest reply: Dec 10, 2014 7:13 AM by Елена И RSS

    How to get current dimention value in set analysis of chart expression?

      Hi community,


      I'm trying to make a chart:

      - dimention  is MonthYear

      - expression is Sum(Sales) for the Customers with RegistrationDate < start of current  MonthYear in a dimention (they have registered before start of current month)


      I have tryed

      sum({<[CustomerID]={"=([CustomerRegistrationDate]<MonthStart(Min(MonthYear)))"}>} Sales)


      but it filters out all Customers who have registered before the first one month in a chart, so it's not what I need if there are more than one month in a chart.

      So I need to refer to a current value of dimention someway instead of min().


      Any help is appreciated.