Pivot Table Examples: An ultimate collection of 62 use cases for 2020 that make you excel in your job

Avatar
Martin Večeřa

We are very proud to present you an ultimate e-book with 62 Pivot Table Examples.

In this e-book, you’ll find one of the most comprehensive databases of Pivot Table use cases that we have collected directly in the field.

These examples can be directly adopted and instantly used in your company. This can make you excel in your job role.

pivot table examples e-book preview

Sign-up to our newsletter for free Pivot Table Examples e-book and Pivot Tables Cheatsheet download

If you want to refresh your Pivot Table knowledge, have a look at the complete beginners guide we have published recently.

source table for pivot table examples

Try the Pivot Tables Here

Try some of the examples directly in Lumeer here.

Book Contents

This is the complete list of examples this book presents:

  1. Tasks count by their State
  2. Orders count by Completion State
  3. Accounts by Industry
  4. Blank fields
  5. Count of Opportunities by State
  6. Count of Sales transactions by the Product line
  7. List of unique values
  8. Count of Interviews for individual Clients
  9. Count of Server Traffic records by Zone
  10. Sum of Opportunity Values by Stage
  11. Sum of Time worked on components
  12. Sum of complete and incomplete Orders
  13. Count of unique Industries in given Year
  14. Count of reports per Service
  15. Sum of Sales by City
  16. Count of unique Skill sets interviewed for individual Clients
  17. Sum of overall Bandwidth measured across Zones
  18. Interviews count by month
  19. Supermarket Sales amount by the hour of the day
  20. Average Complaint Response Time
  21. Sum of Time worked every Month, capped to hours
  22. Amount of Orders grouped by Months and Years
  23. Sum of Opportunity Values by quarter
  24. Sum of overall Bandwidth measured over Months
  25. Relative Sales by Product line
  26. Relative count of Accounts in our portfolio by the year of the first contact
  27. Relative count of Orders by their payment status
  28. Relative time spent working on each project Component
  29. Relative number of Complaints by Years
  30. Relative sum of Opportunity Values by quarter
  31. Relative count of Interviews per quarters
  32. Relative overall Bandwidth measured across Zones
  33. Tasks by Assignee and State
  34. Accounts by Industry and Lead status
  35. Sales by Product line and Gender
  36. Sales by Supermarket and the hour of the day
  37. Interviews by Client Name and Date
  38. Value of Orders by Completed? and Paid? state
  39. Gross Income by Product Line and Branch
  40. Count of Opportunities by quarter of Date logged and State
  41. Relative Count of Orders by Completed? and Paid? state
  42. Relative count of Accounts by Industry and Lead status
  43. Relative Gross Income by Product Line and Gender
  44. Relative Gross Income by Gender and Product Line
  45. Relative Gross Income relative to Product Line and Gender
  46. Relative Time worked on a project by individual Assignees
  47. Relative value of Opportunities according to State and Priority
  48. Relative count of Interviews by quarters and Position Type
  49. Relative overall Bandwidth measured across Zones and Months
  50. Relative count of Accounts by Industry and Lead status filtered to most significant Industries
  51. Relative amount of Sales by Branch, Gender and Product Line
  52. Tasks by Stage and Due date in quarters, count
  53. Tasks by Stage and Due date in quarters, Difficulty sum
  54. Tasks by Stage, State and Due date in quarters, count of Task
  55. Tasks by Assignee and State, count of Task, sum of Difficulty
  56. Relative Orders Total amount by Month and Year, and average Order value
  57. Relative Sales amount by the Day of week and Hour of the day
  58. Relative count of Opportunities according to State and Priority per quarters
  59. Relative count of Interviews by quarters, Industry and Position Type
  60. Relative count of Interviews by Industry, quarter and Position Type
  61. Relative average Bandwidth and average count Users in Zones across Weeks
  62. Relative average number of Users in Days of the week and Hours of the day

Why do you need Pivot Tables?

Pivot Tables can quickly reveal many useful information in our records/data that were originally unknown to us or not obvious at first sight.

For example we can quickly spot any invoice after a due date. Or we can see how many tasks are planned for our team.

Pivot Tables are one of the basic business analytical tools. Their usage is essential to anyone who wants to base their decisions on hard facts. So that your decisions are the best you can make.

Pivot Table Examples

We will be using the standard terms for the Pivot Table settings like Row Label, Column Label, Summation Value that we listed in our Pivot Table Guide.

Every single Pivot Table Example describes the purpose (usage), the individual settings (Row Label, Column Label, Summation Value), possible alternatives and references to other examples that are based on them.

Sign-up to our newsletter for free Pivot Table Examples e-book and Pivot Tables Cheatsheet download

Already leaving? Save 1 day every week guaranteed!

We have analysed the time saved by teams that already joined Lumeer. Get 52 days back every year!

By pressing the Subscribe button, you agree to our newsletter terms and conditions.