Excel - Quick Guide - Tutorials Point Column labels − A field that has a column orientation in the pivot table. Each item in the field occupies a column. Report Filter − You can set the filter for the report as year, then data gets filtered as per the year. Row labels − A field that has a row orientation in the pivot table. Each item in the field occupies a row.