Excel Magic Trick 1418: PivotTables Ranking For Unit & Total Profit for Products within Manufacturer

preview_player
Показать описание
Download Files:
See how to use Standard PivotTables to rank profits and profits per unit for both All The Products and Products within Manufacturer:
1. (00:10) Introduction
2. (01:31) PivotTable #1 for Total Profit per Product and Ranking of Profits for each Product within Manufacturer. See the Show Values As Rank Feature.
3. (06:21) PivotTable #2 for Ranking of Profits for each Product
4. (07:40) Create Custom List so PivotTable will Sort Correctly
5. (09:10) PivotTable #3 for Unit Profit and rank for each Product within Manufacturer. See how to create a Calculated Field in a Standard PivotTable (NOT a DAX Formula)
6. (12:23) PivotTable #4 Ranking Product Profit
7. (14:08) Summary

Related Videos:
Excel Magic Trick 1417: Excel Functions Ranking For Unit & Total Profit for Products within Manufacturer
Excel Magic Trick 1418: PivotTables Ranking For Unit & Total Profit for Products within Manufacturer
Excel Magic Trick 1419: RANKX DAX Function & More: Ranking Profit for Products within Manufacturer
Excel Magic Trick 1420: Ranking in Power Query: Sort, Grouping, Indexes and Custom Columns
  1. excelisfun
  2. Excel
  3. Microsoft Excel
  4. Highline College
  5. Mike Girvin
  6. excelisfun
Рекомендации по теме
Excel Magic Trick 0:14:28

Excel Magic Trick 1418: PivotTables Ranking For Unit & Total Profit for Products within Manufact...

Excel Magic Trick 0:12:10

Excel Magic Trick 1417 Excel Functions Ranking Unit & Total Profit for Products within Manufactu...

Excel Magic Trick 0:27:06

Excel Magic Trick 1419: RANKX DAX Function & More: Ranking Profit for Products within Manufactur...

Excel Magic Trick 0:07:03

Excel Magic Trick 1425: Convert 2-Way Table to Single Column Table with INDEX & Number Incremen...

How To Display 0:03:44

How To Display The Rank By Using Pivot Table In Excel?

Add Rank Field 0:01:09

Add Rank Field To Pivot Table

Excel Magic Trick 0:04:33

Excel Magic Trick 1422: Power Query M Code: Join all Items From Invoice into One Cell

Excel Magic Trick 0:06:07

Excel Magic Trick 1414: Power Query Text.PadStart Function to Correctly Format Account Numbers

Excel Magic Trick 0:12:14

Excel Magic Trick 1427: DAX GEOMEANX function: Average Compounding Rate per Period for FV Calc

Excel Magic Trick 0:06:52

Excel Magic Trick 1439: DAX Measures to Create Cross Tabulated OR & AND Logical Test Sales Total

Excel Magic Trick 0:10:30

Excel Magic Trick 1454 DAX Measure Count Customer Totals Between Upper Lower Limits, Each Month

Excel Magic Trick 0:04:41

Excel Magic Trick 1404: Sales Per Working Day by Month using Power Query

Excel Magic Trick 0:06:07

Excel Magic Trick 1438: Excel Formula to Create Cross Tabulated OR & AND Logical Test Sales Tota...

Excel Magic Trick 0:07:51

Excel Magic Trick 1112: Clean Transactional Data, Then Create PivotTable Monthly Cost Report

Excel Magic Trick 0:12:51

Excel Magic Trick 1420: Ranking in Power Query: Sort, Grouping, Indexes and Custom Columns

Excel Magic Trick 0:08:00

Excel Magic Trick 1437: DAX Query OR Logical Test IN Operator: Pull Sales Team Data to Excel Sheet

QQ34 Ranking with 0:09:44

QQ34 Ranking with Pivot Table by DAX

Excel Magic Trick 0:12:12

Excel Magic Trick 1434: SAMPLE DAX Function to Take Random Stratified Sample from Data Set.

Excel Magic Trick 0:28:07

Excel Magic Trick 1424: Average, Moving Average at Different Granularity: DAX or Excel Formulas?

Excel Magic Trick 0:28:34

Excel Magic Trick 1330: Append All Excel Tables in Current Workbook: Power Query (Get & Transfor...

Microsoft Excel - 0:02:41

Microsoft Excel - Pivot Table Top 10 (or Top 1, 2, 3, etc.)

Excel Magic Trick 0:12:09

Excel Magic Trick 1426: Lookup Row & Column Headers From 2-Way Lookup Table with Unique Values

Rank Fields in 0:05:06

Rank Fields in a PivotTable

How to rank 0:03:09

How to rank with a pivot table

Комментарии
Автор

The workaround with the custom sort was handy when working with the standard pivot tables. Thanks for the video!

shoeshines
Автор

hi Mike,
As usual, thank you to teach us so many ways with workaround as bonus. It helps us to think out of the box!

EricGiroux
Автор

no word to say.just excellent as our mike always does :)

bohemaxxtum
Автор

I like your fun tricks and workarounds here :) looking forward to the DAX.

LeilaGharani
Автор

That's pretty good Mike, Thanks very much.

MuhammetMustafaAslan
Автор

Mike, nothing is impossible for you in Excel.

iuh
Автор

Muito bom, agora aprendi como detalhar mais com visão simplificada nas tabelas dinâmicas!
Parabéns e muito obrigado!

samuelbarros
Автор

Hi Mike! Thnk's for your job, it's Great. Jusy got your book C-S-E! That's awsome! Waited it for couple months ;)

ikark
Автор

Thank you, Mike !
Very impressive and useful!.
I am looking forward to more examples for DAX!
How to create P&L reports in DAX maybe?
Thank you again for your excellent work.

georgekaroubas
Автор

Hey! Just recently committed to learning excel and I stumbled upon your amazing channel! I have a task that I've been assigned for a construction company. The goal is to build an interactive dashboard of where I can filter and sort different products from different suppliers in order from cheapest to most expensive. You may have covered a similar problem in another video but there are just too many videos to look through!

Any help would be much appreciated! Thanks

djgrandma
Автор

In the case of ranking equal values, does the PivotTable act like a Rank.Eq or a Rank.Avg?

allenzrzer