Chart Pivot Table

Jamal — Wed, 26 Apr 2023 11:43:04 GMT

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

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.

topic Chart Pivot Table in QlikView