Forum Discussion
Solved
Excel Pivot - Move Row to Column (wants to sum the text)
Hello, I have a pivot and I do not like the format of it. I want to move the the row for "description" (the red starred in the pic below) from the row to the column but when I do this it wants...
Not something you'll find on a Mac mathetes , I'm afraid.
You'll need the DAX formula to create a measure in the Data Model, that will allow you to drop a text in the value field of the pivot table. The end result then looks like this:
hi Mathes, thank you for the response. To make it simple, can you drag the decription field to the column? You see that it sums and it is text. Do you have a crafty way of being able to display a text field in the column but simply display (no summing).
thank you.
I did drag it there, and just saw that it made the set of columns ridiculously long....and useless. I didn't see what you seem to be describing. Can you post a picture of what you're describing and don't want? But also come up with some better description or manual creation of what you do want. I gather that the two images I sent back don't come any closer to the cross-tabulated result than what you already had. It would help if you gave feedback rather than just reiterating what your first post said.
Not something you'll find on a Mac mathetes , I'm afraid.
You'll need the DAX formula to create a measure in the Data Model, that will allow you to drop a text in the value field of the pivot table. The end result then looks like this:
- Thanks for that explanation. Yet another (fortunately minor) Mac limitation.