Problem regarding Total in Pivot Table

[sarfaraz_sheikh]

Dear All,

I am using below code however i am not getting the proper total .I am using Pivot table

Kindly suggest what should i have to do for getting right total . Snapshot and QVW file is also attached here for your refernce.

Load * inline

[D_NO,Remarks,id
  1, Excellent,02
  1, Faboulous,01
  2, Very_good,03
  2, Faboulous,01
  3, Good,04
  3, Faboulous,01
  4, Average
  4, Performance
  5, Poor,05
  5, Performance
];

EMPP:
LOAD FIRST_NAME,
     LAST_NAME,
     SSN,
     BIRTH_DATE,
     ADDRS,
     SEX,
     SALARY,
     SUPERSSN,
     D_NO,
     START_DATE
FROM
C:\Users\Sarfaraz.Sheikh\Desktop\QVD_Files\EMPP.QVD
(qvd);

Exit script;

Sarfaraz

[sarfaraz_sheikh]

Dear All,

Please find the attached QVW file .

Sarfaraz