When I try to do a pivot table, I lose the text values. I tried to split the column but it does not work for me.
When I try to do a pivot table, I lose the text values. I tried to split the column but it does not work for me.
So what should end result look like?
In general, you can't have text values in Value field of pivot table.
Exceptions being, DAX measure that evaluates to single text value. Ex: Measure:=IF(HASONEVALUE(Table[Column]),"Blah",BLANK())
Which requires Data Model (PowerPivot)
You can have text value in all other fields (Row, Column or Page).
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks