Chart Pivot Table

[Jamal]

HI, 

Please, I need your help.

I have different tables :

1. PROD ( my sales by Mark and place (CDLOC), and RIS, with different dateprodsql (example : 22/02/2022; 12/10/2021;...)
2.  Vente ( market sales by Mark and place (CDLOC),  with dateprodsql= 30/12/2022 OR 30/12/2021)
3. MARKA ( MARK, CODE_MARK,..)
4. AGENCE ( RIS)
5. MasterCalendar

I need to obtain 2 columns mysales ( count  MARK) AND market ( sum(NBRE) byCDLOC,RIS AND MARK , like this 

but, I get this 

I have tried to aggregate by year but I got total  for market

Thank you.