Pivot Table Can Not Add Field to Row

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

The Field (column on the work sheet) is text. It is "=left(A2,3)".
I have tried as a caluclated field. I tried Copy, Paste Special, Value.
I can use the field as a filter or column but not as a row.
"The field you are moving cannot be placed in the Pivot Table area."
 
If this is an Excel question, you're in the wrong newsgroup. This is for
FrontPage.
--
Tom [Pepper] Willett
Microsoft MVP - FrontPage
"You're a daisy if you do!"
---
FrontPage Support:
http://www.frontpagemvps.com/
===
: The Field (column on the work sheet) is text. It is "=left(A2,3)".
: I have tried as a caluclated field. I tried Copy, Paste Special, Value.
: I can use the field as a filter or column but not as a row.
: "The field you are moving cannot be placed in the Pivot Table area."
 
Back
Top