👉 Up4Excel Downloads Library: »» ml.up4excel.com/library ✅ FREE Access to ALL Up4Excel Files. Includes Excel Templates, Training Workbooks, Example Data, Cheat Sheets and more. New Content Added Weekly!
🔵 Make your Pivot Table look like a professional report in no time. 📗 Download this workbook: »» cutt.ly/up4v1929MFD 🔴 Hide those ugly Pivot Table features for good!
Can I hide columns from the source data when the user drill-down to the data source? For example: my source data have columns A, B, C, D, E but when the user drills down they only see columns A, B, C.
Not that I'm aware of. But you can disable drill down in the options and either: setup the pivot with +/- expanders to drill down to only what you want to show, or use a table with slicers. You could combine the last option with power query to automate the whole thing rather than keep separate data sets too.
✅Reduce your working hours with my personal coaching. 👉Details at ml.up4excel.com/htcapp04 - Offer Ends 19th August 2022
Thank you for the instruction.
glad you found it helpful 👍 John
I wanted to hide field headers and you told me exactly what I needed to know with no fuss! Thanks a lot!
Great to hear Emma. Glad to help 👍
👉 Up4Excel Downloads Library: »» ml.up4excel.com/library
✅ FREE Access to ALL Up4Excel Files. Includes Excel Templates, Training Workbooks, Example Data, Cheat Sheets and more. New Content Added Weekly!
Thanks ☺️
My pleasure Anik 👍
Thank you so much your video helped me to hide field headers.....Thank you
Great to hear that 👍
Thanks John. That was FUN!!!
Fun is certainly good John 👍
🔵 Make your Pivot Table look like a professional report in no time. 📗 Download this workbook: »» cutt.ly/up4v1929MFD 🔴 Hide those ugly Pivot Table features for good!
Thank you :). It was very helpful. Cheers!
Glad to hear that Anshul!
Wow! Thank you! 😀
Glad you liked it 👍
Some good tips here! Thanks
Glad it was helpful! 👍
Thanks.. great tips. Thumbs up!!
Cheers Wayne, thanks for the comment 👍
Very nice 👍👍👍
Glad you like it....spread the word 👍👍
Can I hide columns from the source data when the user drill-down to the data source? For example: my source data have columns A, B, C, D, E but when the user drills down they only see columns A, B, C.
Not that I'm aware of. But you can disable drill down in the options and either: setup the pivot with +/- expanders to drill down to only what you want to show, or use a table with slicers. You could combine the last option with power query to automate the whole thing rather than keep separate data sets too.
Great !!!!!
Happy to help 👍