Different totals between cognos viewer and Workspace

[peter.almstrom]

Hey!

Ive built a really simple crosstab where i use 2 dimensions nested in the rows and a couple of measures as columns. I then mark both the rows and click the auto summarize to get totals. This works when i drill in the report. But when i drag in this report into workspace the totals will not summarize correct when drilling.

Ive attached an image of the problem.

Ive also tested using aggregate(currentMeasure within set,detail,aggreate in a million combinations but i get this to work properly. Im guessing a bug or does workspace use a different Query Engine than report studio?

Anyone got any ideas?

/Peter