Bar Chart Accumulative Stack

[dennysetiawan]

Hi Expert,

I have a data like following:

The last data in the example is Feb-2017.

I want to create a Bar Chart with the expected result is like:

6 = Total Emp accum. to Feb in 2017

5 = Total Emp accum. to Feb in 2016

24 = Total Emp accum. from Jan to Dec in 2016

Can anyone help me the best practice to get the result?

Many thanks.

[ahaahaaha]

Hi,

May be like in attached file

Regards,

Andrey

[dennysetiawan]

Hi Andrey,

Thank you for your response.

How to make it dynamic? For example if my last data is Mar, so the set analysis should be Sum ({<Month={'Jan', 'Feb','Mar'}>}[# of Emp]). If my last data is Apr, it should be Sum ({<Month={'Jan', 'Feb', 'Mar','Apr'}>}[# of Emp]). etc...

[antoniotiman · Accepted solution]

Hi Denny,

Dimension : Year

Expression ;

Sum({<Month={'>=1<=$(=Max({<Year={'$(=Max(Year))'}>} Month))'}>} NrEmp)

Sum({<Month=,Year={'$(=Max(Year)-1)'}>} NrEmp)

See Attachment.

Regards,

Antonio

[dennysetiawan]

Thank you Antonio. Looks good