Print Page - hello cognos gurus thanks for your help in advance guys

Title: hello cognos gurus thanks for your help in advance guys
Post by: kadavarthyV on 04 May 2009 02:16:02 AM

Hi guys,I have a bar chart showing all columns in report but user wants to see revenue and quantity for cityA and Revenue, quantity and turnover for cityB. doesn't want to see turnover (bar) for city A how can i do that in cognos 8.3 report studio
thanks in advance guys

Title: Re: hello cognos gurus thanks for your help in advance guys
Post by: david.stachon on 04 May 2009 03:22:33 AM

I cringe, but likely you'll need to do a case statement on your turnover measure. (i.e. make it null if it's city A)

Title: Re: hello cognos gurus thanks for your help in advance guys
Post by: kadavarthyV on 04 May 2009 06:42:17 PM

thanks for u r reply I have tried it actual is the default measure and turnover, quantity and revenue are the series and city A and B and C are the category X axis. I tried with case statement it didn't worked in my case could u plz explain me in detail. how can I show turnover and revenue for city A and Revenue and quantity for City B all three for City C how can hide the bars in Bar chart thanks guys

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: kadavarthyV on 04 May 2009 02:16:02 AM