Print Page - how can i get diifrence between two data items in footer

Title: how can i get diifrence between two data items in footer
Post by: bvk.cognoise on 02 Mar 2011 10:40:39 PM

hi i have report like

product revenue
a 400
b 200

in footer of revenue i need difference between' b 'and' c like

product revenue
a 400
b 200
difference 200

please solve this issue .appreciate your help

Title: Re: how can i get diifrence between two data items in footer
Post by: PRIT AMRIT on 02 Mar 2011 11:20:26 PM

Create 2 Calculated Data Items

[Data Item A]: Case when [Product]='a' then [Revenue] end
[Data Item B]: Case when [Product]='b' then [Revenue] end

In properties, set Aggregate Function as 'TOTAL'

Create another Data Item [Difference]: [Data Item A]-[Data Item B]
In properties, set Aggregate Function as 'Calculated'

Select, Product column in you list report, then Create a Footer, unlock the report and drag [Difference] into it.

Thanks
Prit

Title: Re: how can i get diifrence between two data items in footer
Post by: bvk.cognoise on 03 Mar 2011 01:45:23 AM

hi
appreciate your help.but I'm not getting exact out put.when I'm trying to do this I'm getting sum of 'a' and 'b' .will you please explain me where I'm doing mistake

Title: Re: how can i get diifrence between two data items in footer
Post by: PRIT AMRIT on 03 Mar 2011 01:53:48 AM

It's just straight forward as I explained in my last post.

Do you mean you are getting error or incorrect result?

Title: Re: how can i get diifrence between two data items in footer
Post by: bvk.cognoise on 03 Mar 2011 02:01:46 AM

yes .

for eg:

year revenue
2004 1000
2005 3000
2006 4000
2007 2000

this is my report .i want to see difference between 2004 and 2006 revenue in footer.how can i do this.i do the same thing what you explained before.but I'm getting incorrect value.
please solve this.very much appreciate for your quick reply.

Title: Re: how can i get diifrence between two data items in footer
Post by: PRIT AMRIT on 03 Mar 2011 02:41:12 AM

QuoteCreate 2 Calculated Data Items

[Data Item A]: Case when [Product]='a' then [Revenue] end
[Data Item B]: Case when [Product]='b' then [Revenue] end

In properties, set Aggregate Function as 'TOTAL'

Create another Data Item [Difference]: [Data Item A]-[Data Item B]
In properties, set Aggregate Function as 'Calculated'

Can you try like this:total([Data Item A])-total([Data Item B])

Hope this should do?

Thanks
Prit

Title: Re: how can i get diifrence between two data items in footer
Post by: bvk.cognoise on 03 Mar 2011 03:03:54 AM

i used same process.i want to know 2005-2004 revenue diffrence.please solve this issue.

Title: Re: how can i get diifrence between two data items in footer
Post by: bvk.cognoise on 03 Mar 2011 03:14:38 AM

hi Prit,

its working :D thank you very much for your quick reply.awesome,

thanks
krishna.dwhc

Title: Re: how can i get diifrence between two data items in footer
Post by: barrysaab on 08 Mar 2011 01:29:33 AM

Thanks,Prit.Great work.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: bvk.cognoise on 02 Mar 2011 10:40:39 PM