Sometimes its the simple things in life. I have a favorite Dictionary record I’d like to share with all of you. It is the constant “1”. What can you do with a Dictionary Record of “1”? First, create a dictionary record with the constant “1” and call it “ITEMS” (see below).
Then if you want to know how many employees you have in each department (Assuming you have an EMPLOYEE file with a DEPT attribute)
LIST EMPLOYEE BREAK-ON DEPT BY DEPT TOTAL ITEMS DET-SUPP ID-SUPP (Your flavor of mutlivalue may vary on this)
You will get a list of departments with the number of employees in each department.
So anything you need to know how many of a certain type of item is in your file, you can modify the above query to provide that information.
Pick Flavor Dict Item (Thanks to Clif Oliver)
Information Flavor Dict Item