How to show text in values area of Pivot Tables

[@aadeorukhkar]

Beautifully explained, sir! I got stuck on the value part and not the text. This helped!

[@efficiency365]

Thanks @aadeorukhkar
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html
Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html
Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html
Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html
Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html
10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html
Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html
Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html
Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html
Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html
Cheers.
Doc

[@dimitririesen]

Great 👍

[@efficiency365]

Thanks Dimitri Riesen for the feedback.
Explore more Excel, Power BI and Analytics videos on this channel ua-cam.com/play/PL-UPeBWRvha2O2TF6vfVw4lfS4honS407.html
Check out my My Udemy courses
Excel to Power BI s.efficiency365.com/upbi
Pivot Tables s.efficiency365.com/mtyt
Learn 130 essential efficiency best practices - read my latest book - s.efficiency365.com/bk
Let me know if you want me to cover any specific topics as well.
Cheers. Dr Nitin (doc) Paranjape.

[@jaswinderbhatti3352]

Thanks sir … you make my life easy ..

[@efficiency365]

Thanks @jaswinderbhatti3352
Check out my other best practices videos as well.
Efficient Tasks Management 2024 - ua-cam.com/video/DJcxPtu-rcg/v-deo.html
Microsoft Teams Meetings - 16 Best Practices - ua-cam.com/video/l3Bvq-I0hy4/v-deo.html
Microsoft Teams - 15 Best Practices - ua-cam.com/video/W8Ufx_znKxI/v-deo.html
OneDrive Best Practices Part 1 - ua-cam.com/video/D7ZrfphW4vo/v-deo.html Part 2 - ua-cam.com/video/nFx6YQxc-b4/v-deo.html
Smart and Effective Email - 5 powerful ways - ua-cam.com/video/6NEFSMqHgQE/v-deo.html
Outlook Calendar Best Practices : Part 1 - ua-cam.com/video/GzsQnecjAQo/v-deo.html and Part 2 - ua-cam.com/video/padKH8ys5Cs/v-deo.html
OneNote - Best Practices - ua-cam.com/video/m-4AY1cMi8s/v-deo.html
Microsoft 365 Best Practices - ua-cam.com/video/kVC_YcL5ObU/v-deo.html
Cheers. Doc.

[@David.Savage]

That was super useful, thanks a lot!

[@efficiency365]

Thanks David Savage.
Check out my other best practices videos as well.
Efficient Tasks Management - ua-cam.com/video/vLFpWVfUfQ8/v-deo.html
Microsoft Teams - 15 Best Practices - ua-cam.com/video/W8Ufx_znKxI/v-deo.html
Smart and Effective Email - 5 powerful ways - ua-cam.com/video/6NEFSMqHgQE/v-deo.html
Outlook Calendar Best Practices : Part 1 - ua-cam.com/video/GzsQnecjAQo/v-deo.html and Part 2 - ua-cam.com/video/padKH8ys5Cs/v-deo.html
OneNote - Best Practices - ua-cam.com/video/m-4AY1cMi8s/v-deo.html
Microsoft 365 Best Practices - ua-cam.com/video/kVC_YcL5ObU/v-deo.html
Word Tables Best Practices - The ultimate guide - ua-cam.com/video/ueKCHxNUOkA/v-deo.html
Cheers. Doc.

[@sassyme2100]

Super helpful! Thank yoi

[@efficiency365]

Thanks @sassyme2100
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html
Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html
Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html
Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html
Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html
10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html
Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html
Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html
Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html
Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html
Cheers.
Doc

[@daivarajackiene9048]

It would be nice to see if pivot filter works with this value of text

[@efficiency365]

There is Value Filter in Pivot. But it accepts only numbers.
Why not use conditional formatting to highlight based upon the filter condition?

[@aizuddindoshah5366]

Thank you, this tutorial save me lot of time for my work.
But for my case, i have numbers of characters in the text to be shown and when i want to put the defined mesure field into the Values area, excel gave me this error "This PivotTable field isn't available because it exceeds the total number of characters that a cell can contain."
Trick is to just go to PivotTable Design > Grand Totals > Off for Rows and Colums. The error is gone, and you will get the table that you want.

[@efficiency365]

Excellent.

[@MrAkshay435]

Hi sir very useful tool but need to know can we use this tool for the big size data like for inventory reports I think this tool is suitable for small set of data like attendance sheet correct me if I am wrong.

[@efficiency365]

When you say this "tool" are you talking about Pivot Table or conditional formatting?
Conditional formatting will work fine with large data.
If you are talking about handling large data in Pivot Table, then you must use Data Model for fast performance.
Once your data is in the data model, you can use the DAX approach for creating custom measures as shown here.
Watch this video to learn more about using the Data Model.
Handle millions of rows in Excel - Fast Analysis - Data Model - ua-cam.com/video/93h7rRsLF7Y/v-deo.html

[@littlekidscartoonplanet]

how use in excel pivot table calculated filed If text column CONTAINS specified value, give me what I want?

[@efficiency365]

Hi @chillfire00
Filter on text column - use Contains.
Try it and let me know if that works for you.
Check out my other best practices videos as well.
Efficient Tasks Management - ua-cam.com/video/vLFpWVfUfQ8/v-deo.html
Teams Meeting - Agenda, Action Points, Notes - ua-cam.com/video/k0t8_mNkMDw/v-deo.html
Microsoft Teams - 15 Best Practices - ua-cam.com/video/W8Ufx_znKxI/v-deo.html
OneDrive Best Practices Part 1 - ua-cam.com/video/D7ZrfphW4vo/v-deo.html Part 2 - ua-cam.com/video/nFx6YQxc-b4/v-deo.html
Smart and Effective Email - 5 powerful ways - ua-cam.com/video/6NEFSMqHgQE/v-deo.html
Outlook Calendar Best Practices : Part 1 - ua-cam.com/video/GzsQnecjAQo/v-deo.html and Part 2 - ua-cam.com/video/padKH8ys5Cs/v-deo.html
OneNote - Best Practices - ua-cam.com/video/m-4AY1cMi8s/v-deo.html
Microsoft 365 Best Practices - ua-cam.com/video/kVC_YcL5ObU/v-deo.html
Cheers. Doc.

[@littlekidscartoonplanet]

@@efficiency365 it doesnt work

[@efficiency365]

If you want to filter on the text field added to the Value area, then go to the row / column field dropdown and choose Value Filter and choose "Contains".

[@niteeshmishra2790]

I am still waiting for Hindi channel to come.🙏😊😊

[@efficiency365]

Hi Niteesh...
Yes. I know. It is taking longer. Working on it.
I know it is important to start a Hindi channel.
But I have some other workload which I need to finish first.
Thanks for your patience.
Doc.