Show values smaller than (Growth Rate)

[heitorcarlosgomes]

Hi,

I'm having trouble with a formula. I'm trying to show all growth rates year by year, without one year.

Measure green bar is 

(Sum({<Ano>}[Volume_projetado])/above(Sum({<Ano>}[Volume_projetado]-1))-1)

That plot all years 2016 to 2022.

Im trying 2016 to 2021 (without 2022)

That was all my attempts, and i failed: 

• aggr(only({$<[Ano]={"<2022"}}[Volume - Consolidado]>), Sum({<Ano=>}[Volume_consolidado])/above(Sum({<Ano=>}[Volume_consolidado]-1))-1)
• (Sum({<Ano={"<=2021"}>}[Volume_consolidado])/above(Sum({<Ano={"<=2021"}>}[Volume_consolidado]-1))-1)
• (Sum({<Ano={"<2022"}>}[Volume_consolidado])/above(Sum({<Ano={"<2022"}>}[Volume_consolidado]-1))-1)

What I supose to do?

Tks

[BrunPierre]

Like this perhaps

(Sum({<Ano={'*'}-{2022}>}[Volume_consolidado])/above(Sum({<Ano={'*'}-{2022}>}[Volume_consolidado]-1))-1)