In this video I answer a client's Pivot Table question. Bob wanted to display the actual data from a column in the data source in the Values section of the Pivot Table but Excel would only display a count. Bob came to me for help.
🗒 Notes and Resources
Download a copy of the file used in this video: app.box.com/s/ph83l8cg89m3ychm9jbcffc9afvpdjke
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: twitter.com/theexceltrainer
Facebook: facebook.com/theexceltrainer
LinkedIn: linkedin.com/in/thomasmik
#excel #pivottable
- Excel: Pivot Table Hack - Display Actual Data Instead of Sum or Count ( Download)
- How Can I Show Text in the PivotTable Values Area Instead of Numbers | Display Unique Text Values ( Download)
- You Won't Believe These Crazy PIVOT TABLE Hacks! ( Download)
- PivotTable Text Values Alternative ( Download)
- Advanced Pivot Table Techniques (to achieve more in Excel) ( Download)
- How To Show Text In PivotTable Values Area ( Download)
- I don't use PIVOT tables anymore... I use this other thing instead! ( Download)
- How to make a Pivot Table always display all the field values even when they contain no data ( Download)
- Show Values As in Excel Pivot Table ( Download)
- 🧙♂️ Pivot Table Excel Tips & Tricks ( Download)
- Pivot Table Trick 4 - Group Date Fields (Must Know!) ( Download)
- Excel Magic Trick 1115: PivotTable to Count How Many of Each Item There Are In a Column ( Download)
- PivotChart and Pivot Table - Remove sum of ( Download)
- Pivot Table Hacks: Show Yes/No in a Pivot Table ( Download)
- Display Texts in the Pivot Table (!Go to Description for better video!) ( Download)
