9 Replies Latest reply on Apr 15, 2018 5:45 PM by FRANCK DO

Cumulate SALES from last 5 month reported in a unique month ex : MARCH

Hi communauty !

I need to create a Calcul for cumulate SALES in MARCH with the last 5 month passed ONLY  FOR A TYPE "COGE"

TOTAL SALES ONLY IN THE MONTH OF MARCH FOR "COGE" TYPE = SALES (November Year-1  + December Year-1 + January Year + February Year  + March Year)

Exemple :

For the MARCH 2019  TOTAL SALES FOR =  Sales November 2018 + Sales December 2018 + Sales January 2019 + Sales February 2019 + Sales March 2019

For The MARCH 2018 etc....

In the folder there is the initial sheet i need to modify and target (what i want in final)

thanks a lot !!!

• 1. Re: Cumulate SALES from last 5 month reported in a unique month ex : MARCH

HI Franck

Hope this helps.

Thanks,

Shin

• 2. Re: Cumulate SALES from last 5 month reported in a unique month ex : MARCH

Hi Shin

THANKS A LOT !!!

But i wonder if it's possible to exclude the table calculation ? with a more complex calculation ?

like :  IF date part month=3 then WINDOWS SUM SALES (dateadd('month',-4) + WINDOWS SUM SALES (dateadd('month',-3) + WINDOWS SUM SALES (dateadd('month',-2) ...

many thanks

1 of 1 people found this helpful
• 3. Re: Cumulate SALES from last 5 month reported in a unique month ex : MARCH

HI Franck

I understand you don't like table calculation (Me neither).

But this is the case table calculation is needed, and without it is not realistic I think.

To do it, you need to create all respective March's calculation differently with LOD.

Thanks,

Shin

1 of 1 people found this helpful
• 4. Re: Cumulate SALES from last 5 month reported in a unique month ex : MARCH

Shin,

Thanks for your answer, i'll try to use more often table calculation in the futur

Could you just send me your exemple of lod calcul for 2020

i'll try to create all respective March's calculation differently with LOD and compare the best solution for my need.

many thanks, you are very helpful for me !

franck

1 of 1 people found this helpful
• 5. Re: Cumulate SALES from last 5 month reported in a unique month ex : MARCH

Thank you Shin !

That's ok i saw the 10.5V2

best rgds