Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to obtain in the set analysis below the months of
Oct 2021, Sep 2021, Aug 2021.
The month Nov 2021 is correct.
aggr(FirstSortedValue([Previous],-Aggr(Min({<[CODIGOGRUPO]={'1'} >}Datex),Produto)),Produto)
It gave me a total blank.🤔
sum({<Ano ={$(=Year( addmonths( today() ,-4)))},Mes={$(=Month( addmonths( today() ,-4)))},DATAHORAX={'$(=MinString(DATAHORAX))'},[CODIGOGRUPO] = {'1'}>}Previous)
😀
aggr(FirstSortedValue([Previous],-
Aggr(Min({1<Ano ={$(=Year( addmonths( today() ,-1)))},Mes={$(=Month( addmonths( today() ,-1)))},[CODIGOGRUPO]={'1'} >}Datex),Produto)),Produto)
DID NOT WORK☹️
sum({<Ano ={$(=Year( addmonths( today() ,-4)))},Mes={$(=Month( addmonths( today() ,-4)))},DATAHORAX={'$(=MinString(DATAHORAX))'},[CODIGOGRUPO] = {'1'}>}Previous)
😀