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.
Thanks,
Nick