List subset by formula
I'd like to create inventory report and included "Item master" as dimension.
However, since there is no stock in 50% of item master, it is obviously waste of cells.
So, I'd like to create list or list subset based on "existing stock only".
One of idea is to create simple module with item master, and add property as boolean with
formula that "IF Qty > 0 THEN TRUE ELSE FALSE", then import this boolean to
list subset finally.
But, since qty of inventory is monthly basis, but item master does not have time dimension,
I'm not sure how to create formula such as "IF QTY > 0 in Jan or Feb or Mar... THEN TRUE