suppress secondary dimension values in chart

[#1]

Hi, I have a bar chart with 2 dimensions and 2 expressions... the 2 expressions are stacked. please see sample image below:

Store A sells all 3 products, B sells only Banana and Orange, C sells only Apple and Orange...

I need to suppress the secondary dimension (label) for the 0 values - i.e., remove Apple for Store B and remove Banana for Store C.

I already tried suppressing the zero values but that doesn't work...

Is this a limitation in QV? Im using version 9, SR5.

Please help. Thanks in advance.

[llauses243]

Hi,

To use variable like dimensión artificial, this with setting OMITT if is NULL, see attach

good luck, Luis

[#3]

Hi Luis,

Thanks for your reply...

I have tried your solution but I dont seem to get it to work, Im not sure if I'm missing something. The chart that Im trying to accomplish should be something like this:

I really appreciate your help. thanks a lot!