HI,
Please, I need your help.
I have different tables :
- PROD ( my sales by Mark and place (CDLOC), and RIS, with different dateprodsql (example : 22/02/2022; 12/10/2021;...)
- Vente ( market sales by Mark and place (CDLOC), with dateprodsql= 30/12/2022 OR 30/12/2021)
- MARKA ( MARK, CODE_MARK,..)
- AGENCE ( RIS)
- MasterCalendar
![Jamal_2-1682507626054.png Jamal_2-1682507626054.png](https://community.qlik.com/t5/image/serverpage/image-id/105877iCF74FD755B1F5552/image-size/medium?v=v2&px=400)
I need to obtain 2 columns mysales ( count MARK) AND market ( sum(NBRE) byCDLOC,RIS AND MARK , like this
![Jamal_3-1682507914278.png Jamal_3-1682507914278.png](https://community.qlik.com/t5/image/serverpage/image-id/105878iE67ADD5883CD5C62/image-size/medium?v=v2&px=400)
but, I get this
![Jamal_4-1682508080773.png Jamal_4-1682508080773.png](https://community.qlik.com/t5/image/serverpage/image-id/105879iF47AA0FF47845B51/image-size/medium?v=v2&px=400)
I have tried to aggregate by year but I got total for market
![Jamal_5-1682508862320.png Jamal_5-1682508862320.png](https://community.qlik.com/t5/image/serverpage/image-id/105882i2F429A76DD40EDBF/image-size/medium?v=v2&px=400)
Thank you.