<Total(PMTD GP%)> cell is wrong when the list report is exported to excel 2007

[cognovice]

Hi All,
Please find attached screen shot of the List Headers & Footers and Report Design.

The problem with this report is the <Total(PMTD GP%)> highlighted in yellow.  When the report is run in html, this gives correct GP% calculation but when the same information is exported to excel, it copies the overall <Total(PMTD GP%)> from "Total" row and pastes to all other total rows including "Branch" rows.

Your assistance will be of immense help.

Thank you,

Kind Regards,
R

[cognovice]

Sorry, I am unable to attach the word document as I am getting an error message which says, "An Error Has Occurred!"  "Cannot access attachments upload path!

[cognovice]

Hi All,
Can anybody assist me here please...


Kind Regards,
R