Hi all,

Using Excel 2010.

I am trying to sort a PivotTable but the RowLable field has a Date stored as a Text value for formatting purposes so not sorting correctly
As far as I know, I cannot add another field to the RowLabel w/o the field being in the horizontal axis of the resultant PivotChart, so not an option.

I found this article from jim Thomlinson at answers.microsoft.com. I tried following his suggestion, but when I try to create a PivotTable based on a PivotTable, I get this error:

The PivotTable field name is not valid. To create a PivotTable report, you must use the data that is organized as a list with labeled columns. If you are changing the name of a PivotTablefield, you must type a new name for the field.
The first PivotTable has a date columns as a date so I can sort it. I am hoping that if that is sorted will cause the 2nd PivotTable to be in same sort order and thus PivotChart.

Any ideas?
Thx
w