Column chart with one of its bars dedicated to a single series

[mlodugu1]

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