Display of cumulative results based on a selection

[#1]

Hi all,

I'm a bit stuck with one of my apps:

I've got 2 graphs, one with the sales per week, and beside one with the cumulative results of the first one.

Easy and correct for the whole periode, but to ease the reading of the graph, I'd like to display the final 30 weeks (30 is an example).

So it works properly for the week / week graph, but the cumulative one is only calculating the cumulative results for the last 30 weeks, without taking into account the data of the weeks before the selection.

So I'd like just to make a kind of zoom to read more easily the graph, with keeping the results of the cumulative option based on the whole period.

Does anyone has an idea?

Thanks for your help.

Jérôme.

[Gysbert_Wassenaar]

See this document.

[#3]

Thanks a lot, I'll look through it but it seems to answer to my request!

I'll let you know.

Regards.

Jérôme.

[#4]

My main issue, is with that tip, I'm adding a dimension, and as I need to do a graph after the calculation I'm a bit stuck for the moment...

I'm still chasing for the right method, and I will share.

[#5]

Hi Jerome,

did you find a kind of solution ?

I'm wondering if it is possible to zoom in a line chart for istance a part of it manteining as starting point of zoomed new chart the cumulated value present on original chart. I mean without loosing it and starting as usual from 0 first value.