Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course - Pivot Tables

excel training course - Pivot Tables

ResolvedVersion Standard

Mon 25 Jun 2007, 14:27 Delegate Kirti said...

Kirti has attended:
Excel Advanced course

Pivot Tables

My raw data contains text data also.
How can I get text to appear as a data item on my pivot table?

Fri 29 Jun 2007, 14:49 Trainer Amanda said...

RE: Pivot Tables

Hi Kirti

Thanks for your question.

Unfortunately you can't display text data in the data items area of a pivot table. As an alternative, you could display the text fields in the Row and Column areas, and then show a count of the records in the data items area.

Amanda

Training courses

98.1 % recommend us

More live stats...

Training information:

Excel tip:

Switching Between Spreadsheets

As the Alt+Tab key switches between loaded applications or files, Ctrl+Tab switches between loaded or open Excel files. Hold down the Ctrl key until you have tabbed to the correct spreadsheet.

View all Excel hints and tips