How to summarize a measure in a crosstab if two different dimensions are used

[tushar gaurav]

I have created a crosstab with the following details in a DMR:
1.Rows for Order Method and Product Line
2.Column for Revenue % for year 2013 1nd 2012
Now I need to apply a overall summary  for Revenue % in row both for Order Method and Product Line.
Individually I am able to apply the Summary for Order Method and Product Line ,but I am not able to apply the over all summary for both.
Please refer the excel attached.

[tushar gaurav]

Can anyone plz help me in this issue or plz let me know whether its possible or not..

[bdbits]

Should be possible, but how will the "overall summary" be calculated? You want to add the revenue and calculate the %, or average them, or something else? I am guessing there are two queries in the report for the two row sets - perhaps unioned together?