i have the following as a dimension on a chart
CustomerID & '-' & OrderID
this dimension is on the Y Axis of my chart
I need to use OrderID to show length of time individual orders process through - e.g from warehouse, packing and shipping ..as a stacked bar chart. , otherwise it would just add all the single customers orders together, and I want to show them individually
I have the calculation working no problem
my issue is as follows....
on the appearance section of the chart , I just want to show however the text of the CustomerID and hide the OrderID...on the axis....is this possible?