Pivot Table Example - Sales by sales person
Pivot Table Example - Sales by sales person
Apr 24, 2015
exceljet.net
Find the MAX, MIN & AVERAGE Sales for Each Sales Person in Excel 365 | GROUPBY & PIVOTBY Function with HSTACK Multiple Aggregations! =PIVOTBY(Data[Sales Person],,Data[Sales],HSTACK(MAX,MIN,AVERAGE),,0) =GROUPBY(Data[Sales Person],Data[Sales],HSTACK(MAX,MIN,AVERAGE),,0) | Excel Basement
0:30
Find the MAX, MIN & AVERAGE Sales for Each Sales Person in Ex…
23.8K viewsJan 3, 2025
FacebookExcel Basement
Advanced Analytics on Sales Data using PIVOTBY Function in Microsoft #Excel 365 Sales for Each year by Each Employee =PIVOTBY(YEAR(Data[DATES]),Data[NAMES],Data[SALES],SUM) Percentage of Quarter Sales made by Each Sales Person =PIVOTBY(YEAR(Data[DATES])&"Q"&ROUNDUP(MONTH(Data[DATES])/3,0),Data[NAMES],Data[SALES],PERCENTOF,,,,,,,1) | Excel Basement
1:00
Advanced Analytics on Sales Data using PIVOTBY Function in Micro…
7.1K viewsOct 22, 2024
FacebookExcel Basement
Power BI Dashboard & Reports - Sales Analysis
10:06
Power BI Dashboard & Reports - Sales Analysis
257.9K viewsAug 9, 2017
YouTubeData Bear Power BI Training
How To Use The GROUPBY Function In Power BI - DAX Function Review
8:15
How To Use The GROUPBY Function In Power BI - DAX Functi…
70.7K viewsJul 26, 2019
YouTubeEnterprise DNA
Master the GETPIVOTDATA Function for Dynamic Excel Dashboards
12:27
Master the GETPIVOTDATA Function for Dynamic Excel Dash…
136.4K viewsApr 25, 2019
YouTubeUdemy
Excel GETPIVOTDATA Function to Pull Data from a PivotTable
9:45
Excel GETPIVOTDATA Function to Pull Data from a PivotTable
211.4K viewsSep 29, 2017
YouTubeComputergaga
11:47
Advanced Pivot Table Techniques (to achieve more in Excel)
2.3M viewsApr 8, 2021
YouTubeLeila Gharani
10:18
How to Create Power BI TOP N Report (Power BI Top 10 / Top N Fi…
243.4K viewsOct 31, 2018
YouTubeAvi Singh - PowerBIPro
9:28
Filter Pivot Tables For Month-to-date Mtd Comparisons With Slicers
249.6K viewsJan 22, 2016
YouTubeExcel Campus - Jon
How to create a PivotTable from multiple Tables (easy way)
Nov 11, 2022
exceloffthegrid.com
16:12
PIVOTBY
25 views1 month ago
YouTubeEmpowering Finance with Technology
4:10
PIVOTBY: A Dynamic PivotTable Alternative
12.5K viewsJan 10, 2024
YouTubeExcel University
6:46
Advanced PIVOTBY Formulas - Custom Headers-Totals-Sorting
1.2K viewsMar 13, 2025
YouTubeContextures Inc.
19:34
Excel PivotBy Function: 3 Powerful Examples
5.9K viewsApr 16, 2025
YouTubeOfficeNewb.com
9:31
Exploring the GROUPBY Function in Excel
1.7K viewsFeb 9, 2024
YouTubeChris Menard
10:57
[Excel] Introducing the new "PIVOTBY" function! (It's importan…
27.4K viewsMar 27, 2024
YouTubeわちょんのゆっくりIT
4:30
Create Date Hierarchy in Excel Pivot Table
6K viewsMar 5, 2024
YouTubeExcelDemy
12:38
Excel’s GROUPBY and PIVOTBY explained
155 views10 months ago
YouTubeCPA Australia
5:47
PIVOTBY Function in Excel | Automatic Refreshing Pivot Table …
3.3K viewsJun 18, 2024
YouTubeSpreadsheet Power
10:37
Master Conditional Formatting in Excel (The CORRECT Way)
184.8K viewsFeb 18, 2024
YouTubeKenji Explains
11:26
Master the New GROUPBY & PIVOTBY Functions in Excel
44.6K viewsMar 30, 2025
YouTubeKenji Explains
8:57
How To Use The GROUPBY Function In Power BI [2023 Update]
28K viewsFeb 14, 2023
YouTubeEnterprise DNA
11:18
How to use a Pivot Table to Analyze SALES DATA in Excel
121.8K viewsApr 3, 2020
YouTubeYoda Learning Academy
24:49
Show TopN Products and Others in Power BI
96.1K viewsApr 2, 2021
YouTubeGoodly
17:34
Excel PIVOTBY Tutorial ➗ Including Calculated Fields
1.3K viewsApr 24, 2025
YouTubeProlific Oaktree
1:16
Excel Pivot Table: How To Sort By Values
109.3K viewsApr 20, 2022
YouTubeCogwheel Learning
12:08
Try The NEW GROUPBY Function Instead of Pivot Tables
611.7K viewsMay 26, 2024
YouTubeKenji Explains
5:38
Explore GROUPBY and PIVOTBY Functions in Excel (NEW EXCEL F…
2.7K viewsJan 16, 2024
YouTubeMaven Analytics
3:13
Bring a column value from one table to another table in Power BI | LOO…
27.1K viewsJul 29, 2023
YouTubeLearning Science
See more videos
Static thumbnail place holder