COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: mc09 on 08 Jun 2009 09:35:35 AM

Title: how to do like "total colA for distinct colB"?
Post by: mc09 on 08 Jun 2009 09:35:35 AM
is there any way to do in this way?
Title: Re: how to do like "total colA for distinct colB"?
Post by: dumbell on 14 Jun 2009 07:38:35 AM
This will be total 3 calculations.

(1)Total(ColA)
(2)distinct (ColB)
(3)aggregate(1) for (2)

Let me know, how it goes?