1 Reply Latest reply: Jun 12, 2014 11:57 PM by Sergey Makushinsky RSS

    Set analysis with Aggr Function

    Ankit Gupta

      hi guys,

                     i have one issue in using set analysis -

                          =Sum({$<Year = >} aggr(DISTINCT(Value),%Key))

                     i want all Year, so want to exclude any year selection and aggr distinct function too..

                     in dimension i am using month and FY.

                     % Key is combination of Territory and Dates.

                     this code is not working for me...please if anyone can solve it....

       

                     please check attachment for more details.