Excel Pivot Tables - Add a Column with Custom Text

See how to add a column (or row) of custom text to an Excel Pivot Table. The table will stay dynamic, and if you update the source data, the table will update with it. The column can contain any text that you want. Also, you can freely move and format the rest of the table once you make these changes.

#excel #spreadsheet #timesheet

[richardmaxwell]

This is awesome. Thank you. I have spent at least 15 hours looking for this exact answer.

[master_blizzard]

This is such an obscure function. I'd never heard about it and I think it can be extremely helpful. Thank you so much!

[ThomasFriedow]

I like that Idea a lot. I had used this method, but included an Xlookup command fom my raw table.
In my case I wanted a pivot showing text matching a row/column pair rather than costs, count etc.
(I had a table with serial numbers for an assembly (rows) with subcomponent (columns) and I wanted to show the batch-number as values of that pair. Still required some manual work, but the result was what I needed)

[laurenschwarze]

Very very helpful, only resource that has helped me with my problem. Thank you!

[samanthalinton]

this is exactly what I have been looking for! Thank you so much!!

[yumarialferez]

thanks a lot this will save me a ton of time, keep doing it!

[RohitKumar-cczi]

This is owsome, a big thanks from my end just keep it up.

[vitarathiel]

After column inserted in olap format, how to change back in pivot table format ?

[thaivinhnguyen]

This is exactly what I am looking for, however, my current Excel OLAF function does not work (it is there but in greg colour, cannot use it). Do you know why? Thank you very much.

[TheBanjaara]

This doesn't update automatically if a new sales rep is added to the data source. Any change in the sales amount is refreshed though. Is there any workaround for it?

[germancervantesortega]

Great video you got my humble like, once you convert to formulas, can you turn back to pivot table to continue editing?

[SultanDablool]

Great, but how do I change the data source and how to convert it back to pivot

[gavilander]

Sorry, the OLAP tools option is not available for my table, what can I do convert it to formulas?

[Dave-tgpu]

Thank you ! However, for any MAC users, the option to "add this data to the Data Model" is not available. I currently using Excel for MAC version 16.44 and IOS 10.15.7. Excel for MAC does not have several "higher" level capabilities.

[silverli-situ]

Wow this is a game changer. Does Google Sheets have anything similar?

[samawad]

My OLAP button is not active (greyed out), any thoughts? Thanks

[mxyunus]

Amazing video. Very helpful. Many thanks.
If I may, I would like to ask you one question. I work on sales data which changes every day, some deals come in and some go out. My job is to connect with the sellers and take his/her comments on every single deal and make sure tomorrow when data refreshes those comments are aligned with their respective deals.
Currently, I am using Pivot and I created 9 of them for different markets, what I do here to keep the comments aligned are pick a column which is unique paste them outside the pivot, take down notes and when I refresh it tomorrow I do a vlookup beside the comment column and past the vlookup result back into old comment column.
What do I do to get this 9 different pivots in one single view and cut down the manual work?

[ma.chrisinaarriola]

I have a problem if i click the olap button it change to number sign? Can u help. Me

[mwendabaimwendabai]

Thanks for vid, ever knew that functionality was hidden in there. Comment however.
Si followed your steps and it seems to work fine until I add my columns. Is there a way for it to know to add cells to each column when new data is added? Everytime I refresh the pivot to add new data, it only updates the columns form the data source and not the "additional' columns I added. That skews the information in the pivot table i.e. The comments added are no longer referenced to the data for the associated row. Any way to change the setting? Ideally, if it could add the new data towards the bottom of that would be great. Thanks!

[abdallahshalak]

Game xhanger, however when i do that all cells change to #GETTING DATA. So anyone could help on that?