All Values in Axis (List box bypass)

[#1]

Hi ALL,

I'm new here. I think that here is a great community for us (new users/developers) learn from more experienced.

In advance I'm sorry for my english and eventual mistakes.

I'm building a line chart, that indicates the growth trought the years. In other words, I'm using YEAR as the dimension.

I need to check the YEAR in a List Box in other to have other analysis, but when I do that, only one year appears in the line chart dimension. I wish to see all the years in the X-axis.

I can't detach the chart because I wish to use other list box as filter for the line chart.

Is there any way to fix this, and have all the YEARS for dimension, even when one year is selected in the List Box?

Cheers,

LGMF

[Anonymous · Accepted solution]

Luiz,

Simple set analysis will do the job, for example:

sum({<Year=>} Amount)

You need to add it to all expressions in the chart.

Regards,

Michael

[#3]

Thanks for your help, Michael.