Please consider a feature that allows users to hide rows/columns added into an ad-hoc. The purpose of this feature would be custom sorting.
There is a need of custom(non-Alphabetic) sorting of values in a dimension field. One example is the usage of custom months that don't fit calendar dates.
Currently there is no easy way to custom sort these in ad-hoc. The hidden field option would allow to define an ordering column in the dimension, that could be added in the ad-hoc before the field to be displayed.
This would generate the desired custom sorting and once hidden this field would allow desired reporting format with the field being invisible in the end result for the users.