2 Replies Latest reply: Mar 3, 2014 4:50 AM by Manish Kachhia RSS

    Dashbord sum(TOTAL)

    ben lim

      Hi all,

       

      I am trying to create a dashboard for the user therefore, no selection is needed from the user input.

       

      One of the expression that I would like to create is MarketShare by current year.

       

      sum(sales) / sum(TOTAL(sales) will be the market share throughout, however I have ten years of data and I would like to only find the market share for this year.

       

       

      =

      sum({<Year={"$(=max({<Year=>} Year))"}>} sales)
      /
      sum(TOTAL(TEU)<Year = today())

       

      I managed to get the first part correct, however on the second part, how can i find the total sales in one code

       

      thanks