Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
Greetings for the day.
I need to create a stack bar graph. X axis is "Month" and Y axis is "Sum(qty)". Now I need this Y axis bar as stack bar based on field "Customer Code".
I have 200 Customer code's in my file. So i can't give those many expression's. So Is there any other way to create stack bar based on customer code.
Please let me know how to create same. Thanks in advance.
Use 'Customer Code' as second dimnesion. Goto Style tab->Sub Type->Stacked
Hi reena,
can you post some sample file.
Regards,
Muni
Use 'Customer Code' as second dimnesion. Goto Style tab->Sub Type->Stacked
Use Month and Customer as dimension and sum(qty) as expression.
Now in Style tab , change Subtype from Grouped to Stacked.
You will get the stack chart.
Regards
Nitin
Hi Reena,
You Can Add the Month & Customer Code into Dimension & in Expression you can write sum(qty).
then go to Style Tab select subtype as Stacked.
It will give you your expected output.
hope this help.
Regards,
Hi ,
Kindly verify my attachment file.
Regards,
Muni
Like this?
Thanks for replies. I got the solution.