Show all items sometimes?

[dmac1971]

I have a straight table showing a recommended purchase list, around 80 items listed.  I want to show all the items and their subsequent sales, even if the value is 0 I want to see it.  This is fine I have this done, however in doing so I can no longer apply a list box against one of the dimensions.  I'm assuming that as I've disabled "Supress When Value is Null" list boxes will no longer work?

Say the table shows

ITEM - DESC - TYPE - SUBTYPE - REQ QTY - SOLD QTY

And say the list is 10 items long, and we've sold 9, the other one should still show but show zero.  However selecting a SUBTYPE from a listbox will limit the table to that SUBTYPE but still show zero sales to items within that type?

Hope this kinda makes sense.

[sebastianlettner]

Hallo,

just add an new Expression with value 1 to the chart and select Hide Column under the Presentation tab for this column, select Suppress Zero-Values and you should be fine. Plus: you can now set an display condition to the expression with the value and can use this as switch for showing/hiding zero values.