Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I try to have the max value in this set analysis :
sum({<DATE_SEMAINE={"2023-29","2023-30","2023-31","2023-32","2023-33","2023-34","2023-35","2023-35","2023-36","2023-37","2023-38"}>} VENTES_QTE_HEBDO)
I want get the MAX(ventes_qte_hebdo) for these 10 week.
For example if the max(ventes_qte_hebdo) is for the 2023-32, then I GOT the value of the max(VENTES_QTE_HEBDO) for the 2023-32.
I need the max(sum(ventes_qte_hebdo)) for these week
I tried a lot of things with bottom, toppom ... and aggr but it returns me never the result I expect.
Thanks in advance
Hi @Fred12 ,
Maybe this:
Max( Aggr( sum({<DATE_SEMAINE={"2023-29","2023-30","2023-31","2023-32","2023-33","2023-34","2023-35","2023-35","2023-36","2023-37","2023-38"}>} VENTES_QTE_HEBDO), DATE_SEMAINE ) )
I hope it can helps.
Best Regards
Hi @Fred12 ,
Maybe this:
Max( Aggr( sum({<DATE_SEMAINE={"2023-29","2023-30","2023-31","2023-32","2023-33","2023-34","2023-35","2023-35","2023-36","2023-37","2023-38"}>} VENTES_QTE_HEBDO), DATE_SEMAINE ) )
I hope it can helps.
Best Regards
Thanks, it works !