Full Accumulation is not working in Trellis chart

[Anonymous]

Dear Friends,

I have a trellis Chart with daily Sales and Forecast values by showing separate chart for each product group and every small individual chart is being displayed at daily.is not showing accumulated total. Please find the attached image. If you see normal chart, accumulation is working where as in trellis it is not working.

Please suggest how to make accumulation works in trellis??

Br,

Chinna

[Gysbert_Wassenaar]

I think the only way is to create an AsOf table that links each day with all its previous days. See this blog post for more information: The As-Of Table

[Anonymous · Accepted solution]

Dear Gysbert,

Thanks for your suggestion. I have managed to make it work in other way by sing below expression.

Also I have unchecked the "Full Accumulation" option after using the below expression). It is working fine in Trellis.

RangeSum(above(sum(Sales),0,RowNo()))

Br,

Chinna