Hi friends :),
I am trying to create a 3d stacked column chart that has one of its bars displaying a different series alone while all the other bars display the common series. The bar in question should display only one series that is different from the common series.
for example: assuming,
measure: quantity
xaxis(category) items: Product line, products(all)
series1: Sales region
series2: product line
for the chart, but I also want the last bar of the chart to display members of the product line level, i.e, camping equipment, Mountaineering equipment etc as the series or stacks. Hence this bar representing products(all) should not display sales region as the series.
I could display the bar by dragging products(all) dimension into the category axis, but the sales region series continues to display even for this bar which I don't want. Please let me know how I can achieve such a chart with one of its bars that is restricted to only one of the series.
thanks
mlodugu1