Hi everyone!
I am having trouble with showing the cumulative % .
In my chart:
I have 2 dimensions (Year and Product ID) and one measure (Value).
I want each product id to individually add to 100% over time. But right now, I am getting them to sum to 100% together at the end of my time period.
This is the expression which I am currently using
Aggr(Rangesum(Above(sum(Value)),0,rowno()))/sum(Total Value)), Product_ID, Year)
Any help is appreciated!
Thank you!