4 Replies Latest reply: Jul 31, 2014 9:40 AM by Pedro Barabanov de Assis

# How can I heap in a second dimension?

Hi, everyone!

I need to solve this problem and can't think of a solution.

I have this graph:

I need to heap the second quarter (2ºTri/2010) plus first (when user select first and second quarter, I need to heap the sales - in this case, 12.275 in the first quarter and 12.275 + 12.504 in the second quarter). There's the option "Accumulation" in the "Expression" tab, but when I select this option, it's heap by Administrator (Administradora), like this:

The definiton of this expression is: "=SUM(QTD_COTAS_SUBSCRITAS)"

Can someone help me?

• ###### Re: How can I heap in a second dimension?

If you have only 2 values in 2nd dimension, try to put something like

=SUM(QTD_COTAS_SUBSCRITAS)+Alt(Above(SUM(QTD_COTAS_SUBSCRITAS)),0)

Will not work with more values.

• ###### Re: How can I heap in a second dimension?

Yeah, it works fine! But I really need it to, at least, 4 values (1st, 2nd, 3rd and 4th quarter in a year)!

=/

• ###### Re: How can I heap in a second dimension?

RangeSum(Above(SUM(QTD_COTAS_SUBSCRITAS),0,4))

• ###### Re: How can I heap in a second dimension?

It works!

Just a correction: RangeSum(Above(SUM(QTD_COTAS_SUBSCRITAS),1,4)).

In my case, I put "SUM(QTD_COTAS_SUBSCRITAS) + RangeSum(Above(SUM(QTD_COTAS_SUBSCRITAS),1,4))"

and works. With 0, gets some wrong values.

But really, really thanks!