For ages we've been asked if we can query and group against just top level categories.
We can query against title, or against parent, using equals or "equals category" and this is very flexible.
But we have quite distinct tier 1 categories, e.g.:
Each of which have many sub-category levels (sopme of which may be called the same).
So querying against category title = "printer" may return both IT and FM calls, as both have suncategories called that.
Grouping against category where the query equals category "IT" will return hundreds of sub groups.
Querying against parent, simply shifts one layer up, which of course may not even exist.
We want to be able to group against just the top levels, so we would get a result somehting like
Finance = 324
IT = 3454
HR = 77
FM = 134
Anyone know how we could do this? Possibly create a new field and a calc that records the ultimate parent when the category is selected?
Any useful ideas welcomed.