Hello,
We have a Cumulative Market Share Growth chart for company wise. We have used the below expression for cumulative. This is working fine in a table, Company wise each month cumulative sales is showing correctly in table. But when we use same expression in chart, the value differs. This is happening due to we have given Month as Dimension and Line as Company Name. When we interchange Company Name as Dimension and Line as Month, representation of chart changes and cumulative values are shown correct.
Since it is a trend chart, it must show month wise cumulative. Is there any alternate option on this or any other way to correct. Please help on this. I have attached the screenshot of table and chart.
=rangesum(above(sum({<Date={">=$(=YearStart(max(Date),0,4))<$(=AddYears(MonthEnd(max(Date)),0))"}>}sales)
,0,RowNo()))
/
RangeSum(above(total sum({<Date={">=$(=YearStart(max(Date),0,4))<$(=AddYears(MonthEnd(max(Date)),0))"}>}sales_aggr),0,RowNo()))
Here, sales_aggr is the field we have aggregated in script based on Product and Date.
