The category report only works on a 1:1 level. I currently have all categories with 3 levels: grandparent>parent>child. this means only the level 3 reporting works for me in the category report.

I want to be able to also review how my top level categories are performing. the report should automatically roll up for me, and level 1 and 2 should populate without me needing to split out the category values.

we could technically split the categories out, but this then has a negative influence on any child category rules we have in place