Generate a pivoted dataset for an ad-hoc query
value must be an integer greater than zero.
Successful response