Dashbord sum(TOTAL)

[n1ef5ng1]

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

[alexandros17]

=

sum({<Year={"$(=max({<Year=>} Year))"}>} sales)
/
sum(TOTAL {$ <Year={"$(=max({<Year=>} Year))"}, myCode = {'TEU'}>} Sales)

[MK_QSL]

sum({<Year = {'$(=Year(Today()))'}>}sales) / sum(TOTAL{'Year = {'$(=Year(Today()))'}'}sales)