I am creating an Ad Hoc View and I have included a distinct count measure .
The view displays a row with a heading of Measures and then FieldName(DistinctCount) displayed to the right.
This row is showing up in the reports based on the view and I can't figure out how to hide it.
Is it possible to hide the measure heading? If so, how?
In Ad Hoc, if you're creating a 'table' view, you can right click on the Column Header and choose the 'Edit Label' option. You could then change the Label to something more appropriate. It needs something. Just spaces or an empty string won't work.
If you're doing a crosstab or a chart, and using a domain, you would need to edit the domain's Display section and change the field's name there.
If you created the field from the Ad Hoc itself, you're not going to have much recourse. You might consider creating a derived table or a calculated field in a domain that creates the distinct count, then using the above mentioned Display section to manipulate its label.
Hope that helps.