MAX in set analysis between week

[Fred12]

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

[agigliotti · Accepted solution]

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

[Fred12]

Thanks, it works !