Accumalate 1 part of dimension

[pauldamen]

Hi All,

I have a stacked bar which shows the status off a project over time. The time is each month and the stacked bar consists of a couple of statussus: open, in progress, closed. The expression is just a count for the number of projects.

What I need is that alle projects that are NOT closed move from 1 month to the next. So for example I have 40 open projects in November. 10 get closed, so in December it should show 30 open projects. How the date works is that it picks up a single date for the month the status changed.

How can I get open projects to move? I tried the accumulation but then it also accumulates the closed projects which it should not do.

Thanks for the help.

Regards,

Paul

[pauldamen · Accepted solution]

I found the solution, I made separate expression for the statussus and removed the status from the dimension. Now I can set the accumulation for individual expressions.