I'm not sure that I completely understand. However, I think what you want is for the values to continue summing. Instead of computing based on Pane, right click on it and have it compute using Period.
Hope this helps!
I want Year number not to be cummulative and when i drill down Quarter number it should be cumulative.
As of now the Quarter numbers are fine but my year number are getting added.
For example 2012 year number in the attached workbook is 876 but it is showing 1684 which is nothing but cummulative of 2011 + 2012 (808+876).
Thanks & Regards
What if you make a copy of your "Period" field, and place it as the first pill on the Columns shelf as a datepart/trunc to Year. Then do not show the header for this pill.
This way it will always create a Pane on year.
Example in attached (v7)
Cumulative - error jm edit.twbx.zip 205.2 KB
Thanks for your reply, but my problems still continues.
The basic Aim of my Dashboard is to see the full year numbers to be displayed as a Sum and the drill down ( Quarters) to be in running total which is cumulative.
In your attached file we could see the full year in sum which is perfectly fine but when it comes to drilling down to quarters the numbers also show up as sum , these numbers should be in cumulative.
Are you referring to the label not being the same as the y-axis value?
If so, then that is because I did not touch your table calculations, and they are different, the one on the Rows shelf is a running total, and the on on the Label shelf is a Moving sum, with 1 value prior.
If this not what you are talking about, I will need you to provide a screenshot marked up to point out exactly what is wrong, and details on what it should be.
I got the solution. I developed on the file you had send where by i just changed from Moving Calculation to Running sum there by i was able to see the right number which i was looking for thanku so much.