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