Accumulation values for the selection in the chart

[#1]

Hi all,

I am showing one line chart with the fullaccumulation.By default it is showing all the data with the accumulated values and it is fine.

But if i made any selections in the chart,the accumulation is happening for those selected values only.Please help me to achieve this.

Ex: Sample Data

Jan-2008 Feb-2008 Mar-2008 Apr-2008 May-2008

    10             20          25            12          5

FullAccumulation:(By Default) ------>Fine

Jan-2008 Feb-2008 Mar-2008 Apr-2008 May-2008

     10          30              55          67          72

Selections(Feb-2008+Mar-2008+ Apr-2008) ---->Current Scenario

Feb-2008 Mar-2008 Apr-2008

     20           45           57

But I need ----->Required Like this

Feb-2008 Mar-2008 Apr-2008

    30           55          67

Please find the attachment for your referance.

Thanks in advance.

Regards

Kumar

[Anonymous]

Adding a '1' into the beginning of the set tells it to show all and ignore selections.

Find attached.

Jonathan

[#3]

Hi Jonathan,

Thanks for your reply.

I want the values with accumulate for the selections

Please find the attachment and see the below chart

Regards

Kumar

[Anonymous]

Adding the test for >=$(vMinDate) into your set seems to work. See attached.

Jonathan

[#5]

Hi Jonathan,

Sorry,This is not how i required.

If i made any range of seelctions in the chart the accumulation is happening from the selected selections only.(Not from the Jan-2008).

That is why the chart is not showing the default accumulated values how it shown for the full data for the filtered seelctions.

Please gothrough my first post.

Regards

Kumar

[Anonymous]

Maybe add a starting balance value, by setting up a variable that says something like:

     =Sum({1<T_Date={"<$(vMinDate)"}>} Value)

Then add this in to the expression you use.

Jonathan

[Anonymous]

File attached.

Jonathan

[#8]

Hi Jonathan,

The Startbal value is adding to the each and every value like this

Startbal +  first value

Startbal*2+ second value

Startbal*3+ third value

etc

Hence the values are wrong.

Regards

Kumar

[Anonymous]

A test for if(RowNo()=1,....) might help.

Jonathan

[#10]

Hi Jonathan,

Sorry for the late reply

This is also not giving the actual result.

Regards

Kumar