Chart Problem

[#1]

I have a trellis chart that simply shows sales by month by Salesman. The chart works fine. As soon as I add a cummulative sales line using:

rangesum(top(Sales, 1, RowNo() -0))

all Salesman show up even when they do not have any sales.

Why?

Thanks,

Stephen

[hdonald]

Hi,

The 'Top(Sales,1,RowNo()-0)' bit seems to force every Salesman/Month combination to be displayed, overriding the chart settings for suppress zero/null values.

Adding a further aggregation e.g. aggr(  rangesum(top(Sales, 1, RowNo() -0))  ,Salesman,Month) may solve the problem,

Regards,

HD