Acumulate in object

[fkeuroglian]

Hi Expert i want to create a table that acumulate values, not only show the each value, instead of this sum the previuos month

not show only the value of the month, show the acumulate of every year

i attached an image that i have now, and the qvw and qvd for example

thank you a lot

Fernando K.

I HAVE THIS NOW:

06-2014     10

07-2014     15

08-2014     0

09-2014     5

i want this:

06-2014     10

07-2014     25

08-2014     25

09-2014     30

[sunny_talwar]

Like these:

Or do you want the value to reset each year?

[Mark_Little]

Hi,

Take a look at the below

Peek() or Previous() ?‌

I use them a lot for things like this.

Mark

[fkeuroglian]

Excelent Sunny!

This is was i looking, There is a possibility to add information if there is no registry for the month that Doesnt have any contract?

for example if you select 2015 only show 08-2015 09-2015 and 10-2015 , is the possibility to show the 12 month of the year instead have or not have record?

thank you sunny for all your help always helpfully!

Fernando K.

[sunny_talwar]

So just trying to understand -> Are you looking to get other months were there is not values?

[fkeuroglian]

Yes Sunny

for example if i have this for the year 2015

08-2015     2

09-2015     3

10-2015     8

i want to see this:

01-2015     0

02-2015     0

03-2015     0

04-2015     0

05-2015     0

06-2015     0

07-2015     0

08-2015     2

09-2015     3

10-2015     8

11-2015     8

12-2015     8

Thank you Sunny!

[sunny_talwar]

Does this need to be a pivot table? or straight table will also work? If straight table is okay, you can add another column (I did =Año) and hide the column from Presentation tab and then you will see all the 12 months.

[fkeuroglian]

Sunny, in a simple table as you do it works great, but if i pass to a bar chart do not work

is there any way to do using a chart?

thank you a lot!

Fernando

[sunny_talwar · Accepted solution]

This?

[fkeuroglian]

Thank you Sunny!

perfect

Fernando K.