Forum Discussion
Power Pivot & Data Model: showing text in value field
Hi Everyone! I need help with power pivot and data model. I'm in the process of building a LMS for my department. I'm creating a pivot table to help the IT guys input the curriculum and the trai...
Hello Zsayna, pivot tables cannot show text in the value area. The value area is strictly for numbers. Pivot tables aggregate numbers in the value area to show sum, count, average, etc.
If you could post a small data sample in an Excel file and manually mock up the desired result, we may be able to find a way to achieve that.