Excel pivot table row labels and report filters
I've created a pivot table in excel with the following row labels:
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?
In the short term: I get around this by duplicating the column in the source data.
In the medium term: I'd love to know a better way...
i tried that but it didn't appear, i assumed it was because the information was duplicated. I will try that again and see. Int he meantime, if anyone else has any other suggestions they would be very appreciated.
Unless you inserted a column into the original range you will need to redefine the source data for your pivot, you will also need to "refresh data" in the pivot table. I personally like to use dynamic named ranges for defining source data for pivot tables:
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1