Make appear the number of retirement

[#1]

Hello.

i want to make appear the 'Départ à le retraite' which is the number of retirement but i want the filter stay on Année.

Who can help me.

Best regards

[Peter_Cammaert · Accepted solution]

To the LOAD of FAITDH.qvd, add a single additional column called AnnéeDeRetraite and reload:

LOAD

:

    Charge,

    year(DateRetraite) AS AnnéeDeRetraite

FROM...

Now in your two tables in Départ à la Retraite, change the expression for the currently selected year into:

=Count({<Année=, AnnéeDeRetraite = {"$(=Max(Année))"}>} DISTINCT CleRetraite)

and for the previous year into:

=Count({<Année=, AnnéeDeRetraite = {"$(=Max(Année)-1)"}>} DISTINCT CleRetraite)

Note that you can select multiple values for Année, but the digital displays will only take the maximum year into account.

Good luck,

Peter

[#3]

Thank you very much Peter. It's work.