Hi,
I have created 1 required and 2 optional prompts on ORDER YEAR column, and taken it into column chart along with Product line and Revenue.
X-axis : Product line
Y-axis : Revenue.
Data series: ORDER YEAR.
User may select same Order Years like 2006,2006,2006 for all the 3 prompts. In this case I want to display 3 bars for each Product line. But I am getting only one bar with the total of revenue for 2006 (3 * revenue for 2006).
Could you please help me .
Thanks,