👉 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!
📗 Get Your Video Workbook Template Here: »» cutt.ly/up4v2006MFD 🎯 Let your pivot table do all the work to populate your dropdown lists, so you don't have to. All you need to do is click refresh! Your dropdown list is populated by pivot table.
Hi, I always watch your videos and it is always helpful. Could you please help me develop a functionality where I can switch between 4 different calculated fields(sum of cost, sum of hours, sum of forecast cost, sum of forecast hours) with a drop down list. Like if I select from list the sum of cost the pivot table should show only sum of cost. Hope to hear back soon. This will save my job. Thanks!
The typical way to do something like that would be to structure your data so all the values are in one column and there is another column with the value type (i.e. hours, forecast cost etc). You then add a slicer (or drop down list) on the value type column. Hope that gives you some ideas 👍 John
![[UNCUT] The Loyal Pin ปิ่นภักดิ์ EP.4 (4/4)](http://i.ytimg.com/vi/d3l5rxl5CVo/mqdefault.jpg)
I'm offering personal coaching to only 2 people. Get details now ml.up4excel.com/htcapp04 - Offer Ends 19th August 2022
👉 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!
📗 Get Your Video Workbook Template Here: »» cutt.ly/up4v2006MFD
🎯 Let your pivot table do all the work to populate your dropdown lists, so you don't have to. All you need to do is click refresh! Your dropdown list is populated by pivot table.
Nice one John! Thanks for sharing :)) Thumbs up!!
Thank you too Wayne!
Hi, I always watch your videos and it is always helpful. Could you please help me develop a functionality where I can switch between 4 different calculated fields(sum of cost, sum of hours, sum of forecast cost, sum of forecast hours) with a drop down list. Like if I select from list the sum of cost the pivot table should show only sum of cost. Hope to hear back soon. This will save my job. Thanks!
The typical way to do something like that would be to structure your data so all the values are in one column and there is another column with the value type (i.e. hours, forecast cost etc). You then add a slicer (or drop down list) on the value type column. Hope that gives you some ideas 👍 John
Thank you. All really great but the accent! 🙂
Well not a lot I can do about my accent... but glad you found the video helpful 👍 Thanks for the comment.
@@Up4Excel Thank you again. Not only it's exactly what I was searching for, I have also found other interesting stuff here, so I subscribed too. 🙂
@@orins2052 Great stuff, hope you find a lot more good stuff here in future too 👍