Print Page - How to summarize a filter on a chart?

Title: How to summarize a filter on a chart?
Post by: semsel on 30 Oct 2012 05:51:06 AM

I have a line chart and i'm applying filter to the series (lines). The lines represent the Itemtypes and the filter is to show data only for Sand,Resin, Glass- A, Glass -B etc. But I want to show Glass- A and Glass - B as a single line. how to achieve this?

Title: Re: How to summarize a filter on a chart?
Post by: HalfBloodPrince on 30 Oct 2012 06:11:34 AM

try this create new query calculation as follows for item types

if( [item types] in('Glass A','Glass B' )) then

('Glass A'+' and '+'Glass B')
else
([item types] )

It wil automatically show u the data summarized for glass1 and glass2.

Now to filter this data u also have to put same calculation in ur filter query data item , so that it wil show the option 'Glass A and Glass B'

Title: Re: How to summarize a filter on a chart?
Post by: semsel on 31 Oct 2012 12:10:01 AM

Thanks for your answer !

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: semsel on 30 Oct 2012 05:51:06 AM