How can I sort data on a Hidden column in Excel?
I have a spreadsheet that has a pivot table in it.
Each record has a time group column and a time nbr column in the pivot table.
(i.e. Timegroup = 90 days before and a timenbr of 1 is assigned to this group,
Timegroup = 60 days before and a timenbr of 2 is assigned to this group,
Timegroup = 90 days before and a timenbr of 1 is assigned to this group.
)
Sorting by the timenbr will put the timegroups in the order that I want in the pivot table.
I don't however want the timenbr column to be displayed. I want to hide that column.
Problem is where this column falls in the spreadsheet. It falls in column B which is also the same column that my page fields fall in the top lefthand corner of my pivot table. If I hide timenbr, I also hide those page field selections.
Looks something like this...
column A Column B
Zone Great Plains <<<< choose which zone you want here...
West
Pivot table at bottom looks like this...
State Timenbr Timegroup
AZ 1 90 Days before
AZ 2 60 days before
AZ 3 30 days before
If I hide timenbr, I end up hiding the page field selections above in column B... how can I still sort my data by timenbr, and not display the information in the timenbr column?