Home 
Search 
Today's Posts 
#21




Using text values in Pivot Tables
On Wednesday, May 15, 2019 at 1:24:31 PM UTC4, wrote:
go to values add value calculated field (at the bottom of the field list) set 'Summarize by' to 'Custom', and use the formula: =TO_TEXT('field_title') This is VERY helpful. Thank you for this creative solution. Hopefully, in the future Google makes this a directly supported feature. I will note if your original column header has a line break (carriage return) in it as such: Sales Person then you will get the dreaded #ERROR! "Formula parse error". There is a workaround I have found. Temporarily, change the column header you want to reference in the Calculated Field into a single word. In the case above, let's say we changed it to 'Person' (removing the word Sales and the following carriage return from the example above). Now go create the Calculated Field. In this case, the formula would be =TO_TEXT('Person') The field will be created in the Pivot Table without error. Now for the interesting part, you can go change the column name back to the original, and Google Sheets is then smart enough to handle the change. Thanks so much to for the original idea to use the T0_TEXT function. This is a really creative solution. 
#22




Using text values in Pivot Tables
On Wednesday, 15 May 2019 18:24:31 UTC+1, wrote:
go to values add value calculated field (at the bottom of the field list) set 'Summarize by' to 'Custom', and use the formula: =TO_TEXT('field_title') Brilliant! Thank you! 
#23




Using text values in Pivot Tables
On Wednesday, May 15, 2019 at 10:54:31 PM UTC+5:30, wrote:
go to values add value calculated field (at the bottom of the field list) set 'Summarize by' to 'Custom', and use the formula: =TO_TEXT('field_title') Great... your solution saved a lot of time for me. 
#24




Using text values in Pivot Tables
On Monday, August 3, 2020 at 4:34:49 AM UTC+2, wrote:
On Wednesday, May 15, 2019 at 10:54:31 PM UTC+5:30, wrote: go to values add value calculated field (at the bottom of the field list) set 'Summarize by' to 'Custom', and use the formula: =TO_TEXT('field_title') Great... your solution saved a lot of time for me. Hey all, adding on top of what's already shared here, I figured out how to combine all values. ðŸŽ‰ =TO_TEXT(CONCATENATE(Feedback)) I also needed to add new lines to all entries so that they make more sense. 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Pivot TablesText Values?  Excel Discussion (Misc queries)  
Calculating from values in pivot tables  Excel Worksheet Functions  
Pivot Tables  Ranking Values  Excel Discussion (Misc queries)  
Pivot tables with zero/null values  Excel Discussion (Misc queries)  
Supress Zero Values on Pivot Tables  Excel Discussion (Misc queries) 