Add both dimensions by using the "add data" button. Have the one you want the whole bar defined by first, and add a measure such as quantity of the products. Next Click on "Appearance" and under presentation click on "stacked" and "horizontal". Next under "Colors and Legend" under colors unswitch Auto and select by dimension. In the formula bar put the dimension you would like the bar to be separated by.
In this case you have to modify your data in script.
This is my data definition:
Load * Inline [
For your uses you have to create fictive group Product:
'Product' as Product,
Drop table Data;
After, you can create bar chart with two dimension ProductCategory and Product and also you can change type of chart to stack in presentation menu.
I added qvf.
Have a nice day,
teste.qvf 192.0 K