8 Replies Latest reply: Apr 13, 2015 6:08 AM by Juan Carlos Vera Hernandez RSS

    Year comparison

    Juan Carlos Vera Hernandez



      I've seen several threads about this subject, but I can't meake this to work in my App.

      The App is showing hierarchical data by (year, month,  Area, Sub-Area, Provider, Location).


      I just want to show a line-chart comparing the dimensions selected against previous period (year). And what I did is create a new measure (Previous Year Sales) as:


      sum( {$<Year = {$(<Year-1)>}>} Sales )


      But I get the same amount than the current year. I've tried with different syntax unsuccessfully.

      Where is the problem here?


      Thanks a lot.