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

    Year comparison

    Juan Carlos Vera Hernandez

      Hi,

       

      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.