•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Changing values on collapsed fields. Data Model/Pivot Tables
I'm using Data Model in Excel because I need weekly data for my locations. Other than scan times, I have no means of seeing the hours worked at a location.
To get the "Estimated Work Hours", I added a measure " =(([Latest Time]-[Earliest Time])*24)" This measure is working as intended.
When I collapse the data, it's still using the measure for my subtotal fields...so it's taking the earliest time and latest time for the week. What I need it to do is sum all the hours for the week. The sum for the week beginning 3/2/2025 should be 2.26 hours, not 5 hours.
Any recommendations on how to deactivate the measure for this subtotal? Or create a new measire to give the desired result?
Thank you!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#real-time data collaboration
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#intelligent data visualization
#Excel compatibility
#rows.com
#Data Model
#Excel
#Pivot Tables
#measure
#Estimated Work Hours
#hours worked
#collapsed fields
#subtotal fields
#Latest Time
#Earliest Time
#sum