I need to use the same field for a PivotTable Report Filter and Row Label. In other words I want to be able to select a filter from a list of row values and display the selected values as rows in my Pivottable. I tried created a calculated field with the value of the field used for the filter, but I get an error message stating that this field can't be used in a pivot area. The pivot area will not let me put the same field in both the filter and row label areas. Is there any other way to do this?