adding text values within

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Adding Text as values within a Pivot Table | Excel forum

Adding Text as values within a Pivot Table | Excel forum

resolvedResolved · Medium Priority · Version 365

Jeevan has attended:
Excel Advanced course

Adding Text as values within a Pivot Table

Is it possible to include a text from source data as a value column within the last column of a pivot table after values?

RE: Adding Text as values within a Pivot Table

Hello Jeevan,

Thank you for your question. I found the following website which shows how to display text in the Values columns of a Pivot Table:

https://sfmagazine.com/post-entry/july-2018-excel-reporting-text-in-a-pivot-table/

I hope this helps.

Kind regards
Marius Barnard
STL

Mon 14 Mar 2022: Automatically marked as resolved.


 

Excel tip:

Changing the Tab Colour of an Excel 2010 Worksheet

Did you know you could give the tabs in your worksheet different colours?

This is particularly useful when organizing all your worksheets relating to a particular period or year, for example.

Right click a tab
Select Tab Colour
And choose your favourite colour!

View all Excel hints and tips


Server loaded in 0.1 secs.