Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I understand that accumulated data points can be shown in the chart by setting it in the 'expression' tab. But i have diffculty showing the figures in text object box. Anyone care to advise on how to calcuate the accumulated data??
Example:
Actual Data: Jan=206, Feb=225, Mar=299
Accumlated data: Jan=206, Feb=431, Mar=730 ( this is the final figure i wanted to show in the text object box)
Would appreciate your help in this! 😃
As there is nothing like Full Accumulation for Text boxes & ur months are also fixed u can write individual 12 formulas for 12 month text boxes
like Jan Text box = Sum(Jan Sales) Feb textbox* = (Jan Sales+ Feb Sales)
Thanks for your suggestion. In this case, is it possible to show only one textbox just for that particular month?