Download the featured file here: bluepecantraining.com/wp-content/uploads/2022/01/Show-Text-in-Values-Area-of-PivotTable.xlsx
In this video I am using PivotTables in Microsoft Excel. I want to display text in the values area of the PivotTable, instead of performing the default COUNT calculation.
To achieve this I am going to use a measure. The measure employs two functions CONCATENATEX and VALUES. CONCATENATEX as the name suggests joins the relevant text values in one text string. VALUES allows us to display unique values only.
------------------------
- How Can I Show Text in the PivotTable Values Area Instead of Numbers | Display Unique Text Values ( Download)
- Show Text in Excel Pivot Table Values Area ( Download)
- Show Unique Text in the PivotTable Values Area Instead of Numbers | Using GROUPBY or PIVOTBY ( Download)
- Excel Text Transformation: Text Instead of Numbers in Pivot Table - Episode 2223 ( Download)
- Show Text in the Values Section of Pivot Table ( Download)
- Pivot Table with Multiple Text Values (Don't Aggregate) ( Download)
- Excel Magic Trick 1115: PivotTable to Count How Many of Each Item There Are In a Column ( Download)
- Count Unique Values in PivotTables in Excel ( Download)
- How to add unique count to a pivot table ( Download)
- Show Text as value in Pivot Table // Text instead of Numbers in Pivot Table in excel (Hindi) ( Download)
- How to count unique values Excel ( Download)
- Two Reasons Your PivotTable Counts Instead of Sums Values ( Download)
- Advanced Pivot Table Techniques (to achieve more in Excel) ( Download)
- Excel - Do a Count of Unique Values | Text and/or Number | Get a Count of Unique Values in Excel ( Download)
- Turn on Filtering for the Values Area of a Pivot Table ( Download)
