Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to build market share bar chart with the time in dimension. And I want to fix these dates to let more visibility for the users.
there is my formula:
sum({$<Year=,Month=>}VolMioPcs/
aggr(NODISTINCT (sum({$<Year=,Month=>} VolMioPcs),
YearMonth)
(YearMonth is the concatenation of Year and Month)
Could some one tell me what is wrong with this?
Thak you in advance
sum({$<Year=,Month=>}VolMioPcs/sum(TOTAL {$<Year=,Month=>} VolMioPcs)
By fixing the dates you mean that even if the user makes a selection on year or month, you still would like to see all the dates?
Best,
Sunny
Yes,
Best regards