Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
When i try to create the trellis chart with quarter and month as dimension and sum(amount) as Expression.
each quarter shows all the month, but i want to show only for Q1 it should be jan-mar, Q2 is Apr-Jun...
I dont know where its going wrong..
is there any bug in Qv11 Sr1.
thanks in advance.
you can create a cyclic group and add this expression.
=if(QUARTER= 'Q1',QUARTER)
=if(QUARTER= 'Q2',QUARTER)
=if(QUARTER= 'Q3',QUARTER)
=if(QUARTER= 'Q4',QUARTER)
i hope you help this solution.
thanks for ur reply,
I want the chart like rohit attachment.
your chart shows q1 for jun and jul and q2 also shows jun and jul.
actually q1 should show only jun and q2 should show only jul.
the same problem i am getting in my chart...
Hi,
I attached the sample trellis chart.
i suppose to show jan - mar in Q1, but it shows all the months in Q1..
similarly for Q2, Q3, Q4.
Could anyone help me to resolve this issue...
thanks in advance.
Hi Rohit,
Could u please tell me whats the difference between ur attachment and my attachment...
both of them same only.
see my req is i dont want to see the months which are not in the quarter.
the chart should be like Jan,Feb,Mar in Q1. i dont want to see any other months in Q1.
Bcoz it will give wrong picture to the end user.
Hi,
Maybe you could check this one.
Regards,
Janzen