Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
l_denivelle
Creator
Creator

Full accumulation - Stop bar after current month

Hi

I have a chart presenting an accumulation of amount on Year N and N-1.

But for the current year I don't want my accumulation to appear after the last month of data.

Knowing that my data are stopped at March 31st 2018.

Any idea ?

regards

1 Solution

Accepted Solutions
anders_thorngaa
Contributor III
Contributor III

Hi Laure,

Pls. see the attached files. Also note, that I have defined 2 variables which are used in the set-formula.

Rgds. Anders

View solution in original post

8 Replies
olivierrobin
Specialist III
Specialist III

hello

maybe specifying a limit on current month in a set analysis

sommenting like : year={'Current Year'],month={'<=current month'} ?

l_denivelle
Creator
Creator
Author

Hi

It works but if I'm displaying only the current year.

By showing last year, all the months are displayed so I think that's why it continues the accumulation on the following months.

olivierrobin
Specialist III
Specialist III

and if you try something like this

sum( ...     if(month<=current month),value,0)  ?

l_denivelle
Creator
Creator
Author

Hi

No it didn't work 😞

Maybe it's not possible if there are other values on the chart.. because without N-1 it works :

but with N-1 :

mt03272mt
Contributor
Contributor

Hey Denivelle,

Recently I had the same problem...

Only one working solution I came up with was playing with colors in the chart.

So you will want to make conditional coloring for current year expression ... make it white and transparent if month is > then current month.

Hope this partial solution helps

anders_thorngaa
Contributor III
Contributor III

Hi Laure,

Pls. see the attached files. Also note, that I have defined 2 variables which are used in the set-formula.

Rgds. Anders

l_denivelle
Creator
Creator
Author

Hi Anders

Yes ! it works !

Thank you

l_denivelle
Creator
Creator
Author

Hi

It's working but I can't find a way to remove the expression values on the chart for the following months :