Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: tushar gaurav on 16 Nov 2015 10:55:35 PM

Title: How to summarize a measure in a crosstab if two different dimensions are used
Post by: tushar gaurav on 16 Nov 2015 10:55:35 PM
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.
Title: Re: How to summarize a measure in a crosstab if two different dimensions are used
Post by: tushar gaurav on 20 Nov 2015 01:19:07 AM
Can anyone plz help me in this issue or plz let me know whether its possible or not..
Title: Re: How to summarize a measure in a crosstab if two different dimensions are used
Post by: bdbits on 23 Nov 2015 10:34:15 AM
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?
Text only | Text with Images