How Can I Show Text in the PivotTable Values Area Instead of Numbers? | Display Unique Text Values
133.7 هزار بار بازدید -
3 سال پیش
-
Download the featured file here:
Download the featured file here: https://www.bluepecantraining.com/wp-...
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.
------------------------
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.
------------------------
3 سال پیش
در تاریخ 1400/10/17 منتشر شده
است.
133,736
بـار بازدید شده