I am attempting to group data by range of value to create a histogram.
When I try to group a set of row labels in the Pivot Table I receive the error message "Cannot group that selection."
After some googling, I realised this was due to there being blanks present in my data.
A solution proposed by various people is to insert dummy values on top of the blanks and filter them out.
I would rather not do this, as the data is used for other Pivot reports - so dear SuperUsers, does anyone know of another workaround to this problem?