ME ROLLUP FAIL, MySQL

Language: Layout:

DROP TABLE MTARGET;
DROP TABLE WHWEEK;
DROP TABLE PIVOT;

CREATE TABLE MTARGET(
codeS VARCHAR(20), 
headcount INT(11), 
version VARCHAR(10), 
RegHrs INT(11), 
Percent VARCHAR(10), 
HrsBdgt INT(11) );

CREATE TABLE WHWEEK(
Code VARCHAR(20), 
VERSION VARCHAR(20),
workhrs INT(11), 
reghrs INT(11) );

CREATE TABLE PIVOT(
selesai DATETIME, 
CODEPivot VARCHAR(20), 
categoryPivot VARCHAR(20),
hours INT(11) );

INSERT INTO pivot VALUES
('2017-04-02','FII','YAA','28'),
('2017-04-09','FII','YAA','28'),
('2017-04-16','FII','YAA','14'),
('2017-04-23','FII','YAA','24'),
('2017-04-30','FII','YAA','41'),
('2017-04-02','RRT','BKK','8'),
('2017-04-09','RRT','BKK','3'),
('2017-04-16','RRT','BKK','16'),
('2017-04-23','RRT','BKK','15'),
('2017-04-30','RRT','BKK','32'),
('2017-04-09','RRT','WESEL','14'),
('2017-04-16','RRT','WESEL','7'),
('2017-04-23','RRT','WESEL','2'),
('2017-04-02','RRT','YAA','67'),
('2017-04-09','RRT','YAA','98'),
('2017-04-16','RRT','YAA','135'),
('2017-04-23','RRT','YAA','103'),
('2017-04-30','RRT','YAA','119'),
('2017-04-02','IDS','YAA','8');

INSERT INTO whweek VALUES
('FII','YAA','144','432'),
('RRT','BKK','144','144'),
('RRT','WESEL','144','144'),
('RRT','YAA','144','1296'),
('IDS','YAA','144','432');

INSERT INTO MTARGET VALUES
('FII','3','YAA','432','8%','35'),
('RRT','1','BKK','144','8%','12'),
('RRT','1','WESEL','144','8%','12'),
('RRT','9','YAA','1296','8%','104'),
('IDS','3','YAA','432','8%','35');

select mtarget.codeS,MTARGET.VERSION, mtarget.headCOUNT, mtarget.reghrs, mtarget.percent, mtarget.HrsBdgt,
whweek.workhrs, whweek.reghrs, concat(round(whweek.reghrs / mtarget.RegHrs),'%') PercentofRegHrs,
    SUM(IF(pivot.selesai = '2017-04-02',pivot.hours,0)) '02-04-2017',
    SUM(IF(pivot.selesai = '2017-04-09',pivot.hours,0)) '09-04-2017',
    SUM(IF(pivot.selesai = '2017-04-16',pivot.hours,0)) '16-04-2017',
    SUM(IF(pivot.selesai = '2017-04-23',pivot.hours,0)) '23-04-2017',
    SUM(IF(pivot.selesai = '2017-04-30',pivot.hours,0)) '30-04-2017',
    IFNULL(SUM(pivot.hours), 0) Total,
    CONCAT(IFNULL(ROUND(SUM(pivot.hours) / whweek.reghrs * 100),0),'%') PercentageA,
    ROUND(IFNULL(SUM(pivot.hours), 0) - mtarget.HrsBdgt) RsltBdgt

from mtarget

left join pivot on 
    mtarget.codeS = pivot.CODEPivot 
    and mtarget.version = pivot.categoryPivot
    
left join whweek on
    whweek.Code = pivot.CODEPivot
    and whweek.version = pivot.CategoryPivot
    
where 
    mtarget.codeS in ('FII','RRT','IDS') 
    AND MTARGET.VERSION IN ('BKK','WESEL','YAA')
Group By mtarget.codeS, mtarget.version;


absolute service time: 0,42 sec