Excel PivotBy function - use multiple fields in rows and columns |

Опубликовано: 29 Сентябрь 2024
на канале: Efficiency 365 by Dr Nitin

1,584

Use the new, powerful #pivotby function in #excel
It replaces #pivot tables in many cases.
To use multiple fields, you need to either use table syntax or HSTACK function.

Sample file download
https://efficiency365.com/wp-content/...

Related videos
GetPivotData macro - Copy from pivot and paste as GetPivotData -    • GetPivotData macro - Copy from pivot ...

Pivot Table Settings You Did Not Know! - Efficiency boosters -    • Pivot Table Settings You Did Not Know...

Distinct count and custom layout in Pivot Table - using Data Model -    • Distinct count and custom layout in P...

Beyond AutoFilter - Use Slicers to filter Excel data and pivot tables -    • Beyond AutoFilter - Use Slicers to fi...

Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster

https://s.efficiency365.com/bk

Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
https://hi.switchy.io/mms

Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://s.efficiency365.com/ptyt
Excel to Power BI - https://swiy.io/uxlpbi

Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: https://efficiency365.com/blog

LinkedIn :   / nitinparanjape
Twitter :   / drnitinp

Production
--------------------
Music and Effects: https://elements.envato.com/
Created using Adobe Premiere: https://www.adobe.com/in/creativeclou...
AI based captions: https://videoindexer.ai (Microsoft service)