Pivot Widget - Hide row values in columns category.

Hi, we have requirement to use a report field only for sorting in pivot widget, this field should not be displayed on the report. Need to hide the entire row which contains values 1,2,3,4,... used on...