Problem with MyDataMart

Hi everyone,

I am having a slight problem importing the database values into mydatamart.

When I create the pivot table I want the values do not much up with the aggregated totals that are stored either in a dataset report or report table.

Here is the pivot table:

And here are the values from the dataset report:

I have tried updating the dmart file several times, however when I create the pivot tables my values are still not equal. I am interested in doing some things at the health facility level and find this a bit easier using the pivot tables, but until the values match up I am unable to do this. Any suggestions would be most helpful.