It would be very useful to be able to create a report from distinct values. This could be distinct textvalues for a legend. It would be similar to the sorting option Hide Repeated Values but without the expty rows.