hello cognos gurus thanks for your help in advance guys

[kadavarthyV]

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

[david.stachon]

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)

[kadavarthyV]

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