Actually i am using a cross tab in my report and trying to calculate a total summary on a nested row . I have explained my issue in the attached document.
Your suggestions are appreciated.
Thanks,
Nithya
If I give SetAggregationproperty of the Total Member to Yes the error is resolved.
Now I set the aggregation method to aggregate instead of Total.And I gave the solve order of 2 .
Now going back to my columns where I dont want to actually total my number of account columns and negative account columns, I set my aggregation property to say minimum, because I want only the no of accounts.
If i give this total value for number of account columns and negative account columns gives the overall minimum value in both the columns and all totals for these columns are same irrespective of the nested rows that is sales rep and accounts.
Is there a way to achieve as in the attached document.
Thanks,
Nithya
Hi Guys,
I am still working on the issue described in the issue.doc attached.
Is there a way to calculate total as described, that is sum for 2 column and find minimum for other 2 column with in the nested group. Setting the aggregate function to minimum finds the overall minimum value of the column instead of considering the nested rows.
Any help is appreciated.
Thanks,
Nithya
Hi Nitya,
Were you able to find a solution to this issue. I'm getting similar issue when trying to upgrade my model to DQM.
Thanks,
Leo