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