I've created a pivot table in excel with the following row labels:
LAST NAME
FIRST NAME
MIDDLE
SUFFIX
DOB
SOCIAL SECURITY #
If I assign the LAST NAME column as a report filter, it removes it from the row labels. I would ideally like the report filter to have the LAST name column as well as the FIRST NAME column, but I would like both columns to still appear as row labels. Can this be done using a pivot table?
Bookmarks