I am trying to create a line trellis chart where the X axis is the Week # and the Y axis is the Sales each line represents a Fiscal Quarter.
Each trellis will represent a product
How do I set up the dimensions to get this to work? I set up the chart without a trellis with the dimensions in this order on the Dimensions tab
Fiscal Quarter
Week #
Product Class
But when I check the trellis button, i get a separate chart for each quarter, not for each product which defeats the purpose of my chart to show Full Accumulation on a weekly basis quarter over quarter. I would attach an image of the chart but do not see an option to do so.
Trellis chart is using the first dimension for the "trellis" effect. In your case, the "Product Class" should be the first dimension, and then each mini-chart will represent an individual Product Class.
I set it up that way but I cannot get the X axis for my line chart use the WorkDay#. It keeps putting my expression as the X axis. Not sure what I am doing wrong.
I noticed the issue I am having is when I use Full Accumulation for my charts. I want to see one trellis shart for each quarter showing daily accumulated bookings but it will not allow it for some reason.
