Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide first 12 data points of MAT

Hi,

I have created a moving annual total using Rangesum and displayed this in a line chart with 13 rolling periods, however the totals start at 0 and then acumulating to the 13 periods. Is there anyway of excluding the first 12 data pionts?

2 Replies
Not applicable
Author

Goto Chart Properties > Dimension Limits > Then under the box titled "Limits "

Select the Option "Restrict the Values which are displayed using first express"

Then under the option "Show Only Values that are"

If you can send me the dimension values I can further help you.

Not applicable
Author

Hi

Thank you for your reply,

However i have version 10 which does not have Demension Limits function.

My dimension value is YearPeriod E.G 2009/10     1 and expression is sum of sales figure accumulated over 13 periods.