Summary Report not grouping
Hey folks, got a problem over here. I've made a summary report that is supposed to group by business unit. And for some reason, it is not. For example, if I were tracking car sales, it should show...
Forum Discussion
I'm wondering if there is some weirdness with leading or trailing spaces in the Brand field. A quick way to test that you be to make a formula field Trim([Brand]) and group on that field.
There must have been data entered earlier by import or free form before the drop down. Or maybe the drop down had a space in it and was later corrected after some data was entered.
I don't know how much data you have but a complete grid edit copy and paste or fill down should clean that up too.
I don't know how much data you have but a complete grid edit copy and paste or fill down should clean that up too.