Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Adding a '1' into the beginning of the set tells it to show all and ignore selections.
Find attached.
Jonathan
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
Adding the test for >=$(vMinDate) into your set seems to work. See attached.
Jonathan
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
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
File attached.
Jonathan
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
A test for if(RowNo()=1,....) might help.
Jonathan
Hi Jonathan,
Sorry for the late reply
This is also not giving the actual result.
Regards
Kumar