Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Like these:
Or do you want the value to reset each year?
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.
So just trying to understand -> Are you looking to get other months were there is not values?
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!
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.
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
This?
Thank you Sunny!
perfect
Fernando K.