- Topics Started - 74
- Replies Written - 52
Thought I’d post an example of a void view using some of the techniques mentioned in earlier posts.
Couple of things – note that the Relationship Filter and the Empty Row properties are set to No. This allows all data to display, even if there is no data, in this case sales, for that row. Sounds good for void reporting until you realize that means ALL, as in all customers and/or all products. You need a way to limit what displays when we are showing empty rows.
So…..in this view only the customers in a particular City are displayed – this is controlled by the relationship of City to Customer, which is defined using the virtual dimension concept. Basically the City is an attribute (PUF) of the Customer SoldTo, so Stratum knows to only show those customers that are in a particular city. Virtual dimensions are one way to control what is listed in a view that has the Relationship and Empty filters set to No.
Also note that only certain Products are listed, instead of ALL products. The list of products is being controlled by a User List that selects a set of target Products. This filter means only those products in the list will display instead of ALL products.
Last note that the blue cells are where we have no product sales for a give customer/product combo. Also note that last years sales are displayed. You could add traffic lites to show where customers bought last year but not this year and/or where sales were down this year vs. last.
Not a bad View if you’re looking for voids within your customer base for certain products. You could do this view at levels above product as well, say product line or group.