Print Page - How to change the 'x-axis query item' dynamically.

Title: How to change the 'x-axis query item' dynamically.
Post by: arroju_venkat on 13 Nov 2008 07:48:50 AM

Hi,

Could you please explain me how to change the 'X-axis query item' dynamically in bar chart by creating a prompt.

Thanks,
Venkat.A.H

Title: Re: How to change the 'x-axis query item' dynamically.
Post by: Suraj on 18 Nov 2008 12:33:39 PM

just replace the x-axis query item by a case stament:
case
when prompt = 1 then [product line]
when prompt = 2 then [product type]
else [year]
end

COGNOiSe.com - The IBM Cognos Community