I have a crosstab report with 2 measures that I'm running in report studio. However when I run the report, the totals are all the same. Please see the attachment for the result screen shot.
I get this message when validating the report -> 'RQP-DEF-0578 A grand total will be returned for measure'
The framework manager also shows the same result. How can this error be fix?
Thank you in advance.
Well, without knowing more about your model and the way you wrote your report, it's not really possible to say.
If I was in the mood to bet, I'd wager your model has not been constructed appropriately - possibly because of missing determinants or ambiguous relationship paths through the data.
MF.