6 Replies Latest reply: Oct 16, 2012 4:28 PM by Nils Andersen RSS

    Bypassing dimension

    Nils Andersen

      Hi,

      I want to create a chart showing gross sales development, but I have a challange.
      Currently I have data for 2011 and 2012. The user always have to select one year.
      Dimension : Year

       

      1) Show sales in year
      Expression : sum({<Year=>} [Invoice Amount Group])

      This work fine and shows a result for both 2011 and 2012


      2) Show increase in %
      Expression : sum({<Year=>} [Invoice Amount Group]) / sum({<Year={2011}>} [Invoice Amount Group])

      This only shows a result for 2011. Where did 2012 go???


      Any ideas to get 2) working


      Kind regards
      Nils