Rolling 4 month accumulated value

[#1]

Hi,

I am looking for inputs on one of the requirement:

I want to show the cumulative totals by Month(assuming Total Sum on Y axis and related month on X axis) in a bar chart.

Below is my Sample data:

Month-Year Sales

Jan-2010         5

Jan-2010         2

Jan-2010         3

Jan-2010         4

Jan-2010         1

Feb-2010         1

Feb-2010         2

Feb-2010         3

Feb-2010         4

Feb-2010         10

Mar-2010         1

Mar-2010         2

Mar-2010         3

Mar-2010         4

Apr-2010         1

Apr-2010         3

Apr-2010         2

May-2010        1

May-2010        1

May-2010        3

May-2010        5

Jun-2010         2

Jun-2010         1

Jun-2010         3

Jun-2010         4

I want to see the last four month data in a bar chart with below result:

Month-Year     Sales

Jan-2010         15

Feb-2010         20

Mar-2010         10

Apr-2010          6

Note: Assume the current selection month is Apr so it is showing rolling last 4 month accumulative value i.e Jan,Feb,Mar and Apr. Each bar represent the respected month total value.

If my current selection month is Jun so it is showing rolling last 4 month accumulated value i.e Feb,Apr,May and Jun.

Thanks in Advance,

Rohit

[hector_munoz · Accepted solution]

Hi Rohit,

I attach a sample... Hope it serves...

Regards,

H

[sunny_talwar]

Or using set analysis (used hector.munoz.innova‌ attached sample to demonstrate how this can be done using set analysis)

[#4]

Thanks Munoz and Sunny. It works.

Can you please help one more thing.

If the current selection month is Apr so it is showing data for rolling last 4 month accumulative value i.e Jan,Feb,Mar and Apr, and a single bar need to be displayed for all four month.

Similarly if we want to display rolling 1 year data than it should display three bars, in which each bar represent accumulated value of four months.

Thanks in advance!!

Rohit

[sunny_talwar]

May be try like attached

[#6]

Just to clarify that i would require rolling last 4 month accumulative data and timeline is for 12 month, then my result should be 3 bars with each bar containing the accumulated data for last four month.

Please find the example as below:

If i have selected month as March then one bar should have the accumulated value of Mar17-Dec16, and x-axis should

display Mar17.

Second bar should have the accumulated value of Nov16-Aug16, and x-axis should display Nov16.

Third bar should have the accumulated value of Jul16-Apr16, and x-axis should display Jul16.

Thanks,

Rohit