Full accumulation with 2 dimensions

[#1]

Hi,

Im creating a bar chart, with Month/Year and Sales status in dimension.

In expression, i'd do rangesum(above(sum(sales),0, row()))

it works without Sales status, how can i make it work with second dimension?

Thanks.

[swuehl]

Have you tried to apply a TOTAL qualifier to the above and the rowno functions?

[#3]

i tried TOTAL, i also tried aggr,  none works, any other ways?

Thanks.

[Gysbert_Wassenaar]

Try: rangesum(above(total sum(sales),0, rowno(total))).

You might also want to take a look at this document.

[er_mohit]

R u tried the simple expression sum(Sales)

and on right side tick on Full accumulation

[#6]

yes, i tried, it works, the problem now is to add 2nd dimension in stacked bar, together in acculation mode, it doesnt work.

Hi Gysbert, i think the total are summing all, and the chart is not in ascending style..