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, it looks like I have found the answer here:
https://www.mrexcel.com/excel-tips/pivot-table-with-text-in-values-area/
you have to add a calculated field but when creating the pivot you need to click a special button "add to data table" and the formula to use is =CONCATENATEX(Values(Table1[your field]), Table1[your field], ", ")
seems very odd because I am not concatenating anything but it does work. I have tested it.
thank you.
https://www.mrexcel.com/excel-tips/pivot-table-with-text-in-values-area/
you have to add a calculated field but when creating the pivot you need to click a special button "add to data table" and the formula to use is =CONCATENATEX(Values(Table1[your field]), Table1[your field], ", ")
seems very odd because I am not concatenating anything but it does work. I have tested it.
thank you.
It very depends on what we would like to show for grouped rows (e.g. for entire month, quarter or year).
If we don't group or only first, when something like
Description_:=FIRSTNONBLANK(Table1[Description], "")could work. If all descriptions in period, when iteration with CONCATENATEX().
Yes, in any case some measure.