Compare Season of Year

[R_Mendoza]

Hello Dear Experts!
I need your help ...... !!!
I would like to compare the SAISON of the year.
The season is 1 and 2 (1/2020 and 2/2020)

For example:

Customer    1/2020   2/2020
A                      $2500       $2000
B                      $4250       $4358
F                      $4274       $4666         

so.. Columns: customer, name, orders from previous season, orders from current season, absolute deviation, deviation in% and there only those customers who have orders in both seasons.

Thank you in advance for your help. Merry Christmas!!!

[Taoufiq_Zarra · Accepted solution]

@R_Mendoza  both seasons=>  1/2020 and 2/2020 ?

can you share a sample data and the expected output ?

[R_Mendoza]

Hello @Taoufiq_Zarra ,

Example:

Regards,

Mendoza