Full guide: cellwise.app/guides/sum-...
How to Sum by Category in Excel (Formula or PivotTable)
Total each category in Excel: SUMIF against a category list, an automatic summary with UNIQUE, sorting by total, a PivotTable, and fixing stray spaces.
cellwise.app
November 5, 2026 at 3:40 AM
Full guide: cellwise.app/guides/sum-...
Apple Watch HRV to CSV in HealthSave: each reading is a row, heart_rate_variability, value in ms (SDNN).
One value per day: PivotTable, Date in Rows, Average of Value, one Source.
https://healthsave.app/guides/export-hrv-and-sleep-data/?utm_source=bluesky_hs14_d09
One value per day: PivotTable, Date in Rows, Average of Value, one Source.
https://healthsave.app/guides/export-hrv-and-sleep-data/?utm_source=bluesky_hs14_d09
November 6, 2026 at 2:00 PM
Apple Watch HRV to CSV in HealthSave: each reading is a row, heart_rate_variability, value in ms (SDNN).
One value per day: PivotTable, Date in Rows, Average of Value, one Source.
https://healthsave.app/guides/export-hrv-and-sleep-data/?utm_source=bluesky_hs14_d09
One value per day: PivotTable, Date in Rows, Average of Value, one Source.
https://healthsave.app/guides/export-hrv-and-sleep-data/?utm_source=bluesky_hs14_d09
Need to display revenues and expenses as positive values in your #Excel #PivotTable while still calculating the correct profit or loss?
See how to use #DAX measures to flip the signs of revenue values w/out changing expense values, and keep the bottom-line accurate: www.youtube.com/watch?v=SQkF...
See how to use #DAX measures to flip the signs of revenue values w/out changing expense values, and keep the bottom-line accurate: www.youtube.com/watch?v=SQkF...
Flipping Signs in a Column in a PivotTable
Need to display revenues and expenses as positive values in your Excel PivotTable while still calculating the correct profit or loss?
In this video, Ken shows how to use DAX measures in Power Pivot…
www.youtube.com
October 27, 2026 at 5:18 PM
Need to display revenues and expenses as positive values in your #Excel #PivotTable while still calculating the correct profit or loss?
See how to use #DAX measures to flip the signs of revenue values w/out changing expense values, and keep the bottom-line accurate: www.youtube.com/watch?v=SQkF...
See how to use #DAX measures to flip the signs of revenue values w/out changing expense values, and keep the bottom-line accurate: www.youtube.com/watch?v=SQkF...
Rutba Office 2.18: Tab as in Word, comments on their words, and filter arrows in Worksheets
Rutba Office 2.18 puts right what the how-to films found. Documents gains Modify Style, comments tied to their words and tracked changes...
https://rutba.io/blog/rutba-office-2-18-documents-and-worksheets
Rutba Office 2.18 puts right what the how-to films found. Documents gains Modify Style, comments tied to their words and tracked changes...
https://rutba.io/blog/rutba-office-2-18-documents-and-worksheets
Rutba Office 2.18: Tab as in Word, comments on their words, and filter arrows in Worksheets
Rutba Office 2.18 puts right what the how-to films found. Documents gains Modify Style, comments tied to their words and tracked changes reviewed one by one. Worksheets gains filter arrows, charts that follow their cells and PivotTable filters.
rutba.io
October 31, 2026 at 2:52 PM
Rutba Office 2.18: Tab as in Word, comments on their words, and filter arrows in Worksheets
Rutba Office 2.18 puts right what the how-to films found. Documents gains Modify Style, comments tied to their words and tracked changes...
https://rutba.io/blog/rutba-office-2-18-documents-and-worksheets
Rutba Office 2.18 puts right what the how-to films found. Documents gains Modify Style, comments tied to their words and tracked changes...
https://rutba.io/blog/rutba-office-2-18-documents-and-worksheets
Day 2 of my live #SelfServiceBI Boot Camp in Bulgaria focused on #PowerPivot and #DataModeling. One of the key takeaways is that Facts and Dimensions should always live in separate tables.
Fact = something that can be aggregated! 🧮
Dimension = how we slice our facts! 🔪
#BusinessIntelligence #Excel
Fact = something that can be aggregated! 🧮
Dimension = how we slice our facts! 🔪
#BusinessIntelligence #Excel
October 21, 2026 at 8:05 PM
Day 2 of my live #SelfServiceBI Boot Camp in Bulgaria focused on #PowerPivot and #DataModeling. One of the key takeaways is that Facts and Dimensions should always live in separate tables.
Fact = something that can be aggregated! 🧮
Dimension = how we slice our facts! 🔪
#BusinessIntelligence #Excel
Fact = something that can be aggregated! 🧮
Dimension = how we slice our facts! 🔪
#BusinessIntelligence #Excel
Svelte Pivottable is a pivot table library with drag & drop functionality ⚡️ - madewithsvelte.com/svelte-pivot...
October 14, 2026 at 10:25 AM
Svelte Pivottable is a pivot table library with drag & drop functionality ⚡️ - madewithsvelte.com/svelte-pivot...
Ep 10 | PivotTables = summarize thousands of rows in 3 clicks 🤯 no formulas needed #excel #exceltips #pivottable #dataanalysis #spreadsheet
Illustrated example with sample data.
Illustrated example with sample data.
October 14, 2026 at 11:30 PM
Ep 10 | PivotTables = summarize thousands of rows in 3 clicks 🤯 no formulas needed #excel #exceltips #pivottable #dataanalysis #spreadsheet
Illustrated example with sample data.
Illustrated example with sample data.
1️⃣ Clean both sources.
2️⃣ Replace "0:00:00" entries with nulls so empty records wouldn't clutter the #PivotTable.
3️⃣ Build shared employee and calendar tables
4️⃣ Write measures to calculate the variance.
The breakthrough was one small step...
2️⃣ Replace "0:00:00" entries with nulls so empty records wouldn't clutter the #PivotTable.
3️⃣ Build shared employee and calendar tables
4️⃣ Write measures to calculate the variance.
The breakthrough was one small step...
October 12, 2026 at 5:12 PM
1️⃣ Clean both sources.
2️⃣ Replace "0:00:00" entries with nulls so empty records wouldn't clutter the #PivotTable.
3️⃣ Build shared employee and calendar tables
4️⃣ Write measures to calculate the variance.
The breakthrough was one small step...
2️⃣ Replace "0:00:00" entries with nulls so empty records wouldn't clutter the #PivotTable.
3️⃣ Build shared employee and calendar tables
4️⃣ Write measures to calculate the variance.
The breakthrough was one small step...
🕒Time intelligence is the collective name for patterns that can be used to solve time comparison problems, such as current VS previous month's sales. 📈 If you do time-based comparisons using #DAX, #Excel #PowerPivot, and/or #PowerBI, this article is for you: exceleratorbi.com.au/dax-time-int...
October 12, 2026 at 5:30 PM
🕒Time intelligence is the collective name for patterns that can be used to solve time comparison problems, such as current VS previous month's sales. 📈 If you do time-based comparisons using #DAX, #Excel #PowerPivot, and/or #PowerBI, this article is for you: exceleratorbi.com.au/dax-time-int...
First plan didn't work, off to the second
paste - sanitize - pivottable BAM
paste - sanitize - pivottable BAM
October 11, 2026 at 2:06 AM
First plan didn't work, off to the second
paste - sanitize - pivottable BAM
paste - sanitize - pivottable BAM
Add a Month with Power Query: Automate Your Monthly GL Consolidation by Jeff Lenning
https://www.excel-university.com/add-a-month-power-query-monthly-gl-consolidation/?utm_source=bluesky&utm_medium=social&utm_campaign=newsletter
https://www.excel-university.com/add-a-month-power-query-monthly-gl-consolidation/?utm_source=bluesky&utm_medium=social&utm_campaign=newsletter
Add a Month with Power Query: Automate Your Monthly GL Consolidation by Jeff Lenning
Learn how to consolidate monthly GL files automatically using Power Query's From Folder feature, then refresh a PivotTable with one click.
www.excel-university.com
October 6, 2026 at 3:10 PM
Add a Month with Power Query: Automate Your Monthly GL Consolidation by Jeff Lenning
https://www.excel-university.com/add-a-month-power-query-monthly-gl-consolidation/?utm_source=bluesky&utm_medium=social&utm_campaign=newsletter
https://www.excel-university.com/add-a-month-power-query-monthly-gl-consolidation/?utm_source=bluesky&utm_medium=social&utm_campaign=newsletter
1️⃣ Clean both sources.
2️⃣ Replace "0:00:00" entries with nulls so empty records wouldn't clutter the #PivotTable.
3️⃣ Build shared employee and calendar tables
4️⃣ Write measures to calculate the variance.
2️⃣ Replace "0:00:00" entries with nulls so empty records wouldn't clutter the #PivotTable.
3️⃣ Build shared employee and calendar tables
4️⃣ Write measures to calculate the variance.
October 6, 2026 at 5:08 AM
1️⃣ Clean both sources.
2️⃣ Replace "0:00:00" entries with nulls so empty records wouldn't clutter the #PivotTable.
3️⃣ Build shared employee and calendar tables
4️⃣ Write measures to calculate the variance.
2️⃣ Replace "0:00:00" entries with nulls so empty records wouldn't clutter the #PivotTable.
3️⃣ Build shared employee and calendar tables
4️⃣ Write measures to calculate the variance.
Or you can try driving the chart from #DynamicArrays so it works off worksheet formulas instead of a #PivotTable.
🧭Takeaway: If a PivotChart keeps breaking on refresh, change the foundation instead of fighting the formatting.
🧭Takeaway: If a PivotChart keeps breaking on refresh, change the foundation instead of fighting the formatting.
September 24, 2026 at 5:18 PM
Or you can try driving the chart from #DynamicArrays so it works off worksheet formulas instead of a #PivotTable.
🧭Takeaway: If a PivotChart keeps breaking on refresh, change the foundation instead of fighting the formatting.
🧭Takeaway: If a PivotChart keeps breaking on refresh, change the foundation instead of fighting the formatting.
catch me in a week talking about pivottable like a pageant mom while i work through the contest tiers
September 18, 2026 at 12:49 PM
catch me in a week talking about pivottable like a pageant mom while i work through the contest tiers
Unpivot with Power Query: Transform Wide Data into Tidy Tables by Jeff Lenning
https://www.excel-university.com/unpivot-with-power-query/?utm_source=bluesky&utm_medium=social&utm_campaign=newsletter
https://www.excel-university.com/unpivot-with-power-query/?utm_source=bluesky&utm_medium=social&utm_campaign=newsletter
Unpivot with Power Query: Transform Wide Data into Tidy Tables by Jeff Lenning
Learn how to unpivot wide monthly data into tidy tabular tables using Power Query in Excel. Includes date headers, totals cleanup, and PivotTable reporting.
www.excel-university.com
September 17, 2026 at 1:20 PM
Unpivot with Power Query: Transform Wide Data into Tidy Tables by Jeff Lenning
https://www.excel-university.com/unpivot-with-power-query/?utm_source=bluesky&utm_medium=social&utm_campaign=newsletter
https://www.excel-university.com/unpivot-with-power-query/?utm_source=bluesky&utm_medium=social&utm_campaign=newsletter
During an AKA call, an attendee brought a stubborn #PowerPivot problem: how do you show a single “Total Units” column in your #PivotTable, but show forecasts monthly without either duplicating a #DAX measure every single month, or ending up with a wall of blank columns that have to be hidden? 🧵
September 15, 2026 at 4:44 PM
During an AKA call, an attendee brought a stubborn #PowerPivot problem: how do you show a single “Total Units” column in your #PivotTable, but show forecasts monthly without either duplicating a #DAX measure every single month, or ending up with a wall of blank columns that have to be hidden? 🧵
I upgraded my Excel PivotTable with these 3 simple features
I’m probably guilty of making Excel spreadsheets more complicated than they need to be, but I have one rule I keep coming back to:...
🔗 https://www.madshrimps.be/news/i-upgraded-my-excel-pivottable-with-these-3-simple-features/
I’m probably guilty of making Excel spreadsheets more complicated than they need to be, but I have one rule I keep coming back to:...
🔗 https://www.madshrimps.be/news/i-upgraded-my-excel-pivottable-with-these-3-simple-features/
September 9, 2026 at 6:33 AM
I upgraded my Excel PivotTable with these 3 simple features
I’m probably guilty of making Excel spreadsheets more complicated than they need to be, but I have one rule I keep coming back to:...
🔗 https://www.madshrimps.be/news/i-upgraded-my-excel-pivottable-with-these-3-simple-features/
I’m probably guilty of making Excel spreadsheets more complicated than they need to be, but I have one rule I keep coming back to:...
🔗 https://www.madshrimps.be/news/i-upgraded-my-excel-pivottable-with-these-3-simple-features/
I upgraded my Excel PivotTable with these 3 simple features
I upgraded my Excel PivotTable with these 3 simple features
Slicers, Timelines, and PivotCharts turned my basic PivotTable into a much more useful tool.
ift.tt
September 8, 2026 at 10:00 PM
I upgraded my Excel PivotTable with these 3 simple features
Das Lösungsvideo Nr. 988: Als erste Überschrift einer PivotTable erscheint oft „Zeilenbeschriftung“. Ursache ist das gewählte Berichtslayout, nicht die Quelldaten. Markus Hahner und Christian Eichhorn zeigen, wie sich dies mit drei Klicks dauerhaft korrigieren lässt. (Lösungsvideo 988)
September 9, 2026 at 4:40 AM
Das Lösungsvideo Nr. 988: Als erste Überschrift einer PivotTable erscheint oft „Zeilenbeschriftung“. Ursache ist das gewählte Berichtslayout, nicht die Quelldaten. Markus Hahner und Christian Eichhorn zeigen, wie sich dies mit drei Klicks dauerhaft korrigieren lässt. (Lösungsvideo 988)
#meta
Still more thoughts about scalable things: UIs, views, the benefits we get from going from one view to another (micro/macro).
The problem is that this view is like a #PivotTable. It's not immediately visible.
Still more thoughts about scalable things: UIs, views, the benefits we get from going from one view to another (micro/macro).
The problem is that this view is like a #PivotTable. It's not immediately visible.
September 6, 2026 at 8:54 PM
#meta
Still more thoughts about scalable things: UIs, views, the benefits we get from going from one view to another (micro/macro).
The problem is that this view is like a #PivotTable. It's not immediately visible.
Still more thoughts about scalable things: UIs, views, the benefits we get from going from one view to another (micro/macro).
The problem is that this view is like a #PivotTable. It's not immediately visible.
During the last AKA call, an attendee brought a stubborn #PowerPivot problem: how do you show a single “Total Units” column in your #PivotTable, but show forecasts monthly without either duplicating a DAX measure every single month, or ending up with a wall of blank columns that have to be hidden? 🧵
September 1, 2026 at 4:04 PM
During the last AKA call, an attendee brought a stubborn #PowerPivot problem: how do you show a single “Total Units” column in your #PivotTable, but show forecasts monthly without either duplicating a DAX measure every single month, or ending up with a wall of blank columns that have to be hidden? 🧵
✨ Quick Tip:
Use Alt + N + V to quickly create a PivotTable and summarize large datasets by categories, totals, counts, or averages in seconds.
Use Alt + N + V to quickly create a PivotTable and summarize large datasets by categories, totals, counts, or averages in seconds.
August 28, 2026 at 12:01 PM
✨ Quick Tip:
Use Alt + N + V to quickly create a PivotTable and summarize large datasets by categories, totals, counts, or averages in seconds.
Use Alt + N + V to quickly create a PivotTable and summarize large datasets by categories, totals, counts, or averages in seconds.
New on CRAN: rpivotTable (0.4.0). View at https://CRAN.R-project.org/package=rpivotTable
rpivotTable: Build Powerful Pivot Tables and Dynamically Slice & Dice your Data
Build powerful pivot tables (aka Pivot Grid, Pivot Chart, Cross-Tab) and dynamically slice & dice / drag 'n' drop your data. 'rpivotTable' is a wrapper of 'pivottable', a powerful open-source Pivot Table library implemented in 'JavaScript' by Nicolas Kruchten. Aligned to 'pivottable' v2.19.0.
CRAN.R-project.org
August 24, 2026 at 9:28 PM
New on CRAN: rpivotTable (0.4.0). View at https://CRAN.R-project.org/package=rpivotTable