You have a column with values that repeat, such as dates (days, months, quarters, years) or categories, and you would like a countvof the number of items in each category?
If this is the case:
- Relate this category column to itself with a match-multiple relation
- Perform a rollup>count on this self-relation
Should you want to create some sort of dashboard, it might help to create a separate table with this categories.