The column must not influence the rows

[JFaucher]

I have a table with several columns, and one column shows the difference between today's amount and the amount one year ago. This calculation shows rows with items opened last year. I'd like this column not to affect the lines displayed, as I don't want them to show data from a year ago, but current data. Do you know how I can set this up?

[Clement15]

Hello,

Sorry, it's in French, but here's an example that works. You need to use an aggr and set analysis

sum({<Année={"$(=max(Année))"}>}aggr(Sum({<Année={"$(=max(Année))"}>}FlagLancement)-Sum({<Année={"$(=max(Année)-1)"}>}FlagLancement),Organisation))