I’m seeking to do a Count of queries that are open with outstanding days in these named categories;
First calculations were done for a variable: xDaysOpen =DaysBetween([Query Open Date];[xCurrentDate])
Now I have these 74 rows (see attached) but would just need to do a count function that will place each of the categories in a columns rather than rows. What is the best approach in handling this summation? Thanks for your support.