Filtering months with negative margin with a checkbox

[oxiofrt]

Hi,

I have a table by year / month. I have a margin for each month.
I would like to be able to filter 'in one click' all graphs in my application on years / months where margin is negative.

A check box entitled 'restrict on neagtive margin month' would be great.

The application herejoined is detailing the problem.

Thanks a lot for your help.

[#2]

There are several different ways to do this that depend on the data model and the situation. I used a calculated field to create a kind of "button" effect while avoiding macros or pre-calculation in the data model. To do this I had to create another field in your data table that combines the Year & Month.

[oxiofrt]

Thanks a lot for your answer.
Ok for the method, does that mean in the application herejoined that I shoud create as many new fieldS as I have aggregation levels ?

[#4]

You would need to add a field to combine DT and Heure and use it in the AGGR() method. ANNEEMOIS can be ignored.

[#5 · Accepted solution]

You need to combine enough fields to match the level (granularity) of aggregation in the chart. Since you have the date, you do not also need the month.

[oxiofrt]

Thanks a lot : -)