Accumulated sums for year and month

[Anonymous]

Hi guys,

I have accumulated amounts per period but what I require is to be able to visualize it in a chart of lines analyzed for months and years, but when going to the chart at line type does not work as shown in the table chart. Please, someone can help me how to solve this problem?

For example for the period January 2016 my result in the point of the graph should be 137733 and not 20710 as it appears in the graph.

Thank you so much.

[aarkay29]

Can you please share your document

Also the above expression i gave would only work for QV version 12 or higher

[Anonymous]

Yes,

This is my document.

NOTE:

Even what I need is that when selecting a date I show the stock quantity from the initial date to 1 day before the selection of date, year, month selected.

For example:

I choose a few months: ene, feb

Then by January 2017 I must show the stock (field: [Ctd.en UM entrada])  from 1 day before that date, from December 31, 2016 backwards.

Thank you very much for your support.

[aarkay29 · Accepted solution]

PFA

Thanks,

Aar.

[Anonymous]

This is correct aarkay29thank you very much!!!!