COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: ahg on 13 Jul 2012 04:27:29 AM

Title: Sub totals on ungrouped records
Post by: ahg on 13 Jul 2012 04:27:29 AM
I have what I think is a somewhat odd question...

I am writing a report for a client who does not want his cross-tab records to be grouped, but wants sub-counts on each would be group of records. Is this at all possible?

Thanks for any replies in advance!
Title: Re: Sub totals on ungrouped records
Post by: Lynn on 13 Jul 2012 08:55:57 AM
Is the objection to grouping due to the fact that the grouped elements down repeat on each row? If so, this post has some techniques to alter the group span.

I tend to think you'll need to do grouping in order to get a sub-total.

http://www.cognoise.com/community/index.php/topic,19463.msg57824.html#msg57824
Title: Re: Sub totals on ungrouped records
Post by: ahg on 13 Jul 2012 09:32:05 AM
That looks useful, thank you!