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

    Bypassing dimension

    Nils Andersen


      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