{"id":2683,"date":"2026-08-07T09:55:23","date_gmt":"2026-08-06T23:55:23","guid":{"rendered":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?p=2683"},"modified":"2026-08-10T10:49:59","modified_gmt":"2026-08-10T00:49:59","slug":"excel-pivot-tables-beginners-guide","status":"publish","type":"post","link":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide","title":{"rendered":"Excel Pivot Tables: A Beginner\u2019s Guide"},"content":{"rendered":"\n<p class=\"has-normal-font-size wp-block-paragraph\">A pivot table is an Excel tool that summarises a large table of data into a compact, interactive report. In a few clicks it groups your data and calculates totals, counts or averages, so you can answer questions like \u201ctotal sales by region\u201d without writing a single formula. To create one, select your data and choose Insert &gt; PivotTable.<\/p>\n\n\n\n<!--more-->\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-dominant-color=\"1f4134\" data-has-transparency=\"false\" style=\"--dominant-color: #1f4134;\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"538\" src=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/excel-pivot-table-beginner-guide-dashboard-hero-1024x538.png\" alt=\"Dynamic Web Training guide hero banner for Excel Pivot Tables: A Beginner's Guide showing a sample summary table with regions, products, totals, and fields areas.\" class=\"wp-image-2684 not-transparent\" srcset=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/excel-pivot-table-beginner-guide-dashboard-hero-1024x538.png 1024w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/excel-pivot-table-beginner-guide-dashboard-hero-300x158.png 300w, https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/excel-pivot-table-beginner-guide-dashboard-hero.png 1200w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Pivot tables have a reputation for being advanced, but they are one of the easiest ways to make sense of a big spreadsheet, and you can build your first one in under a minute. This guide explains what they are, walks you through creating one step by step, and covers the everyday tasks you will actually use.<\/p>\n\n\n\n<h2 id=\"h-what-is-a-pivot-table-in-excel\" class=\"wp-block-heading has-h-4-font-size\">What is a pivot table in Excel?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">A pivot table (Microsoft calls it a \u201cPivotTable\u201d) is an interactive summary of a larger table of data. You give it a long list of raw records, say, thousands of individual sales, and it groups and totals them the way you choose, instantly.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Imagine a sheet with 5,000 rows of sales, each showing a Region, a Product, a Salesperson and an Amount. A pivot table can turn that into a tidy report of total sales by region, or sales by product for each region, in seconds. When you want to see it a different way, you drag a field, and the whole report rearranges, or \u201cpivots.\u201d That is where the name comes from.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">The key point for beginners: a pivot table does the grouping and the maths for you. You do not write any formulas.<\/p>\n\n\n\n<h2 id=\"h-when-should-you-use-a-pivot-table\" class=\"wp-block-heading has-h-4-font-size\">When should you use a pivot table?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Use a pivot table whenever you have a long list of records and you want to summarise it. Typical questions it answers in a few clicks:<\/p>\n\n\n\n<ul class=\"wp-block-list has-normal-font-size\">\n<li>Total sales by region, month or salesperson.<\/li>\n\n\n\n<li>How many orders each customer placed.<\/li>\n\n\n\n<li>Average order value by product category.<\/li>\n\n\n\n<li>A cross-tab, for example products down the side and regions across the top.<\/li>\n<\/ul>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">If your data is a short list you can read at a glance, you do not need one. Pivot tables earn their keep the moment your data is too big to summarise by eye.<\/p>\n\n\n\n<h2 id=\"h-how-do-you-create-a-pivot-table-in-excel\" class=\"wp-block-heading has-h-4-font-size\">How do you create a pivot table in Excel?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Here is the full process with a sales example. It takes about a minute.<\/p>\n\n\n\n<ol class=\"wp-block-list has-normal-font-size\">\n<li><strong>Tidy your data first.<\/strong> Make sure every column has a single, clear heading (Region, Product, Salesperson, Amount) and there are no blank rows or columns inside the data. For best results, select your data and press Ctrl+T to format it as a proper Excel Table.<\/li>\n\n\n\n<li><strong>Click any cell inside your data.<\/strong><\/li>\n\n\n\n<li><strong>Go to Insert &gt; PivotTable.<\/strong> Excel confirms the data range. Choose New Worksheet and click OK.<\/li>\n\n\n\n<li><strong>You will see the PivotTable Fields pane<\/strong> on the right, listing your column headings, with four areas below: Filters, Columns, Rows and Values.<\/li>\n\n\n\n<li><strong>Drag a field into Rows<\/strong> to group by it. Drag Region to Rows and you get a list of regions.<\/li>\n\n\n\n<li><strong>Drag a field into Values<\/strong> to summarise it. Drag Amount to Values and Excel shows the total sales for each region automatically.<\/li>\n\n\n\n<li><strong>Add a second dimension if you like.<\/strong> Drag <strong>Product<\/strong> to Columns to see sales for each product within each region, a full cross-tab report.<\/li>\n<\/ol>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">That is a working pivot table. Everything after this is refining it.<\/p>\n\n\n\n<h2 id=\"h-what-do-the-rows-columns-values-and-filters-areas-do\" class=\"wp-block-heading has-h-4-font-size\">What do the Rows, Columns, Values and Filters areas do?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">The four areas are the whole game, and they are simpler than they look:<\/p>\n\n\n\n<ul class=\"wp-block-list has-normal-font-size\">\n<li><strong>Rows:<\/strong> the field you want listed down the left (for example, Region). This groups your data.<\/li>\n\n\n\n<li><strong>Columns:<\/strong> a field spread across the top, to create a cross-tab (for example, Product).<\/li>\n\n\n\n<li><strong>Values:<\/strong> the number being calculated (for example, Amount). By default Excel sums numbers and counts text.<\/li>\n\n\n\n<li><strong>Filters:<\/strong> a field that filters the whole report from a dropdown at the top (for example, Year), without changing the layout.<\/li>\n<\/ul>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Drag fields between these areas and the report updates instantly. This is the \u201cpivoting\u201d that makes the tool so powerful.<\/p>\n\n\n\n<h2 id=\"h-how-do-you-change-what-a-pivot-table-calculates-sum-count-average\" class=\"wp-block-heading has-h-4-font-size\">How do you change what a pivot table calculates (sum, count, average)?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">By default Excel adds up numbers. To change that, right-click any number in the Values area and choose <strong>Value Field Settings<\/strong> (or <strong>Summarize Values By<\/strong>), then pick <strong>Sum, Count, Average, Max, Min<\/strong> and so on. So the same Amount field can show total sales, the number of sales, or the average sale, just by changing this setting.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">To make the numbers readable, use the same <strong>Value Field Settings<\/strong> dialog, click <strong>Number Format<\/strong>, and apply a currency or thousands format once for the whole field.<\/p>\n\n\n\n<h2 id=\"h-how-do-you-refresh-a-pivot-table-when-your-data-changes\" class=\"wp-block-heading has-h-4-font-size\">How do you refresh a pivot table when your data changes?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">A pivot table does not update automatically when you edit the source data. To update it, right-click anywhere in the pivot table and choose <strong>Refresh<\/strong>, or go to <strong>PivotTable Analyze &gt; Refresh<\/strong>.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">One tip that saves beginners a lot of trouble: if you built your pivot table from an Excel Table (the Ctrl+T step above), new rows you add to the source are included automatically when you refresh. If you selected a fixed range instead, you have to update the range manually under <strong>PivotTable Analyze &gt; Change Data Source<\/strong>.<\/p>\n\n\n\n<h2 id=\"h-how-do-you-sort-and-filter-a-pivot-table\" class=\"wp-block-heading has-h-4-font-size\">How do you sort and filter a pivot table?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">To sort, right-click a value or label and choose <strong>Sort<\/strong>, for example sort regions by total sales, highest to lowest. To <strong>filter<\/strong>, click the dropdown arrow on a Row or Column label, or drag a field into the Filters area for a report-wide filter. For a friendlier filter, select the pivot table and add a <strong>Slicer<\/strong> (Insert &gt; Slicer), which gives you clickable buttons.<\/p>\n\n\n\n<h2 id=\"h-what-are-the-most-common-pivot-table-mistakes-and-how-to-fix-them\" class=\"wp-block-heading has-h-4-font-size\">What are the most common pivot table mistakes (and how to fix them)?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Three issues trip up nearly every beginner:<\/p>\n\n\n\n<ol class=\"wp-block-list has-normal-font-size\">\n<li><strong>Messy source data.<\/strong> Blank rows, merged cells or missing column headings will break a pivot table or produce odd results. Fix: make sure your data is one clean block with a single heading row, and format it as a Table.<\/li>\n\n\n\n<li><strong>Forgetting to refresh.<\/strong> Changed the data but the pivot table looks the same? It has not refreshed. Fix: right-click &gt; Refresh.<\/li>\n\n\n\n<li><strong>New rows not appearing.<\/strong> You added data but it is not in the report. Fix: build from an Excel Table so the range grows automatically, or update the data source manually.<\/li>\n<\/ol>\n\n\n\n<h2 id=\"h-what-is-a-pivotchart\" class=\"wp-block-heading has-h-4-font-size\">What is a PivotChart?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">A PivotChart is the visual version of a pivot table, a chart that stays linked to the summary and updates as you filter or pivot. Create one with your pivot table selected via <strong>PivotTable Analyze &gt; PivotChart,<\/strong> or straight from your data with <strong>Insert &gt; PivotChart<\/strong>. It is the fastest way to turn a summary into a dashboard-style visual.<\/p>\n\n\n\n<h2 id=\"h-how-do-you-get-better-at-pivot-tables\" class=\"wp-block-heading has-h-4-font-size\">How do you get better at pivot tables?<\/h2>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">The basics above cover most everyday needs, but pivot tables go much deeper: calculated fields, grouping dates into months and quarters, showing values as a percentage of the total, and connecting slicers across multiple pivot tables to build dashboards. Pivot tables are also faster to build with Copilot; you can ask <a href=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/microsoft-365-copilot-guide\">Microsoft 365 Copilot<\/a> to create one from a prompt, though it helps to understand the fundamentals so you can check its work.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">If you want to go from confident beginner to genuinely fast, our hands-on <a href=\"https:\/\/www.dynamicwebtraining.com.au\/microsoft-excel-training-courses\/advanced-excel-course\">Advanced Excel Training Course<\/a> covers PivotTables, PivotCharts and data analysis on real business data with a Microsoft Certified Trainer, and the <a href=\"https:\/\/www.dynamicwebtraining.com.au\/microsoft-excel-training-courses\/excel-data-analysis-course\">Excel for Data Analysis Course<\/a> takes you into Power Pivot for very large datasets. If you are still building your formula skills, our guides to <a href=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/xlookup-explained\">XLOOKUP<\/a> and <a href=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/vlookup-vs-xlookup-vs-index-match\">VLOOKUP vs XLOOKUP vs INDEX\/MATCH<\/a> pair well with pivot tables.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For the bigger picture, this guide is part of our <a href=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/complete-guide-to-microsoft-excel\">Complete Guide to Microsoft Excel<\/a>.<\/p>\n\n\n\n<h2 id=\"h-frequently-asked-questions\" class=\"wp-block-heading has-h-4-font-size\">Frequently asked questions<\/h2>\n\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block has-normal-font-size\"><div class=\"schema-faq-section\" id=\"faq-question-1786060014167\"><strong class=\"schema-faq-question\">What is a pivot table used for?<\/strong> <p class=\"schema-faq-answer\">A pivot table summarises a long list of data into a compact report. It groups your records and calculates totals, counts or averages, so you can quickly answer questions like total sales by region or the number of orders per customer, without writing formulas.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1786060029609\"><strong class=\"schema-faq-question\">How do you create a pivot table in Excel?<\/strong> <p class=\"schema-faq-answer\">Click any cell in your data, go to Insert > PivotTable, and choose New Worksheet. In the PivotTable Fields pane, drag a field to Rows to group your data and a number field to Values to summarise it. Excel builds the report automatically.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1786060042081\"><strong class=\"schema-faq-question\">Do you need formulas to use a pivot table?<\/strong> <p class=\"schema-faq-answer\">No. A pivot table does the grouping and the calculations for you. You just drag fields into the Rows, Columns, Values and Filters areas, and Excel produces the totals, so it is ideal for people who are not confident with formulas.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1786060059345\"><strong class=\"schema-faq-question\">How do you refresh a pivot table?<\/strong> <p class=\"schema-faq-answer\">Right-click anywhere in the pivot table and choose Refresh, or go to PivotTable Analyze > Refresh. Pivot tables do not update automatically when the source data changes. If you built it from an Excel Table, new rows are picked up on refresh.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1786060072335\"><strong class=\"schema-faq-question\">Why is my pivot table not updating with new data?<\/strong> <p class=\"schema-faq-answer\">Two common reasons: you have not refreshed it (right-click > Refresh), or your new rows fall outside the original data range. Building the pivot table from an Excel Table (Ctrl+T) fixes this, because the range expands automatically.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1786060080738\"><strong class=\"schema-faq-question\">Can a pivot table show an average instead of a total?<\/strong> <p class=\"schema-faq-answer\">Yes. Right-click a value and choose Value Field Settings, then select Average (or Count, Max, Min). The same field can show a total, a count or an average just by changing this setting.<\/p> <\/div> <\/div>\n","protected":false},"excerpt":{"rendered":"<p>A pivot table is an Excel tool that summarises a large table of data into a compact, interactive report. In a few clicks it groups your data and calculates totals, counts or averages, so you can answer questions like \u201ctotal sales by region\u201d without writing a single formula. To create one, select your data and&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2683","post","type-post","status-publish","format-standard","hentry","category-microsoft-excel"],"yoast_head":"<title>Excel Pivot Tables: A Beginner&#039;s Guide 2026<\/title>\n<meta name=\"description\" content=\"View and Share Dynamic Web Training Blog Archives. This is a great source of articles and posts on Computer and IT training, tutorials and insights\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Pivot Tables: A Beginner\u2019s Guide\" \/>\n<meta property=\"og:description\" content=\"New to pivot tables? Learn what they are and how to create, refresh, sort and format one in Excel, step by step, with a simple worked example.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide\" \/>\n<meta property=\"og:site_name\" content=\"Dynamic Web Training Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-08-06T23:55:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-08-10T00:49:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/excel-pivot-table-beginner-guide-dashboard-hero.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Dynamic Web Training\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:site\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dynamic Web Training\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide\"},\"author\":{\"name\":\"Dynamic Web Training\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/person\\\/c94653aed4a6decc8e357af0a1082233\"},\"headline\":\"Excel Pivot Tables: A Beginner\u2019s Guide\",\"datePublished\":\"2026-08-06T23:55:23+00:00\",\"dateModified\":\"2026-08-10T00:49:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide\"},\"wordCount\":1572,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/excel-pivot-table-beginner-guide-dashboard-hero-1024x538.png\",\"articleSection\":[\"Microsoft Excel\"],\"inLanguage\":\"en-AU\"},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide\",\"name\":\"Excel Pivot Tables: A Beginner's Guide 2026\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/excel-pivot-table-beginner-guide-dashboard-hero-1024x538.png\",\"datePublished\":\"2026-08-06T23:55:23+00:00\",\"dateModified\":\"2026-08-10T00:49:59+00:00\",\"description\":\"New to pivot tables? Learn what they are and how to create, refresh, sort and format one in Excel, step by step, with a simple worked example.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#breadcrumb\"},\"mainEntity\":[{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#faq-question-1786060014167\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#faq-question-1786060029609\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#faq-question-1786060042081\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#faq-question-1786060059345\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#faq-question-1786060072335\"},{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#faq-question-1786060080738\"}],\"inLanguage\":\"en-AU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#primaryimage\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/excel-pivot-table-beginner-guide-dashboard-hero.png\",\"contentUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/excel-pivot-table-beginner-guide-dashboard-hero.png\",\"width\":1200,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Training Blog\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Training\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/category\\\/training\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft Excel\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/category\\\/training\\\/microsoft-excel\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Excel Pivot Tables: A Beginner\u2019s Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/\",\"name\":\"Dynamic Web Training Blog\",\"description\":\"The Ultimate Training Experience.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-AU\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#organization\",\"name\":\"Dynamic Web Training\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/logo.png\",\"width\":361,\"height\":109,\"caption\":\"Dynamic Web Training\",\"name\":\"Dynamic Web Training Logo\",\"description\":\"Dynamic Web Training official site logo asset\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/DynamicWebTraining\\\/\",\"https:\\\/\\\/x.com\\\/dynamicwebtrain\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/person\\\/c94653aed4a6decc8e357af0a1082233\",\"name\":\"Dynamic Web Training\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"caption\":\"Dynamic Web Training\"},\"description\":\"This article is written by a senior writer at Dynamic Web Training. Our specialist writers are either Microsoft Certified Trainers, Adobe Certified Professionals or Certified Xero Advisors.\",\"sameAs\":[\"https:\\\/\\\/www.dynamicwebtraining.com.au\",\"https:\\\/\\\/www.facebook.com\\\/DynamicWebTraining\\\/\",\"https:\\\/\\\/www.instagram.com\\\/dynamicwebtraining\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dynamic-web-training\",\"https:\\\/\\\/x.com\\\/dynamicwebtrain\",\"www.youtube.com\\\/@dynamicwebtraining8740\"],\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#faq-question-1786060014167\",\"position\":1,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#faq-question-1786060014167\",\"name\":\"What is a pivot table used for?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"A pivot table summarises a long list of data into a compact report. It groups your records and calculates totals, counts or averages, so you can quickly answer questions like total sales by region or the number of orders per customer, without writing formulas.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#faq-question-1786060029609\",\"position\":2,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#faq-question-1786060029609\",\"name\":\"How do you create a pivot table in Excel?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Click any cell in your data, go to Insert > PivotTable, and choose New Worksheet. In the PivotTable Fields pane, drag a field to Rows to group your data and a number field to Values to summarise it. Excel builds the report automatically.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#faq-question-1786060042081\",\"position\":3,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#faq-question-1786060042081\",\"name\":\"Do you need formulas to use a pivot table?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"No. A pivot table does the grouping and the calculations for you. You just drag fields into the Rows, Columns, Values and Filters areas, and Excel produces the totals, so it is ideal for people who are not confident with formulas.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#faq-question-1786060059345\",\"position\":4,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#faq-question-1786060059345\",\"name\":\"How do you refresh a pivot table?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Right-click anywhere in the pivot table and choose Refresh, or go to PivotTable Analyze > Refresh. Pivot tables do not update automatically when the source data changes. If you built it from an Excel Table, new rows are picked up on refresh.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#faq-question-1786060072335\",\"position\":5,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#faq-question-1786060072335\",\"name\":\"Why is my pivot table not updating with new data?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Two common reasons: you have not refreshed it (right-click > Refresh), or your new rows fall outside the original data range. Building the pivot table from an Excel Table (Ctrl+T) fixes this, because the range expands automatically.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#faq-question-1786060080738\",\"position\":6,\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/excel-pivot-tables-beginners-guide#faq-question-1786060080738\",\"name\":\"Can a pivot table show an average instead of a total?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Yes. Right-click a value and choose Value Field Settings, then select Average (or Count, Max, Min). The same field can show a total, a count or an average just by changing this setting.\",\"inLanguage\":\"en-AU\"},\"inLanguage\":\"en-AU\"}]}<\/script>","yoast_head_json":{"title":"Excel Pivot Tables: A Beginner's Guide 2026","description":"View and Share Dynamic Web Training Blog Archives. This is a great source of articles and posts on Computer and IT training, tutorials and insights","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide","og_locale":"en_US","og_type":"article","og_title":"Excel Pivot Tables: A Beginner\u2019s Guide","og_description":"New to pivot tables? Learn what they are and how to create, refresh, sort and format one in Excel, step by step, with a simple worked example.","og_url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide","og_site_name":"Dynamic Web Training Blog","article_publisher":"https:\/\/www.facebook.com\/DynamicWebTraining\/","article_author":"https:\/\/www.facebook.com\/DynamicWebTraining\/","article_published_time":"2026-08-06T23:55:23+00:00","article_modified_time":"2026-08-10T00:49:59+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/excel-pivot-table-beginner-guide-dashboard-hero.png","type":"image\/png"}],"author":"Dynamic Web Training","twitter_card":"summary_large_image","twitter_creator":"@dynamicwebtrain","twitter_site":"@dynamicwebtrain","twitter_misc":{"Written by":"Dynamic Web Training","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#article","isPartOf":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide"},"author":{"name":"Dynamic Web Training","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233"},"headline":"Excel Pivot Tables: A Beginner\u2019s Guide","datePublished":"2026-08-06T23:55:23+00:00","dateModified":"2026-08-10T00:49:59+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide"},"wordCount":1572,"publisher":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization"},"image":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#primaryimage"},"thumbnailUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/excel-pivot-table-beginner-guide-dashboard-hero-1024x538.png","articleSection":["Microsoft Excel"],"inLanguage":"en-AU"},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide","name":"Excel Pivot Tables: A Beginner's Guide 2026","isPartOf":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#primaryimage"},"image":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#primaryimage"},"thumbnailUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/excel-pivot-table-beginner-guide-dashboard-hero-1024x538.png","datePublished":"2026-08-06T23:55:23+00:00","dateModified":"2026-08-10T00:49:59+00:00","description":"New to pivot tables? Learn what they are and how to create, refresh, sort and format one in Excel, step by step, with a simple worked example.","breadcrumb":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#breadcrumb"},"mainEntity":[{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#faq-question-1786060014167"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#faq-question-1786060029609"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#faq-question-1786060042081"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#faq-question-1786060059345"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#faq-question-1786060072335"},{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#faq-question-1786060080738"}],"inLanguage":"en-AU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide"]}]},{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#primaryimage","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/excel-pivot-table-beginner-guide-dashboard-hero.png","contentUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2026\/08\/excel-pivot-table-beginner-guide-dashboard-hero.png","width":1200,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Training Blog","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/"},{"@type":"ListItem","position":2,"name":"Training","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training"},{"@type":"ListItem","position":3,"name":"Microsoft Excel","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\/microsoft-excel"},{"@type":"ListItem","position":4,"name":"Excel Pivot Tables: A Beginner\u2019s Guide"}]},{"@type":"WebSite","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/","name":"Dynamic Web Training Blog","description":"The Ultimate Training Experience.","publisher":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-AU"},{"@type":"Organization","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization","name":"Dynamic Web Training","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/02\/logo.png","contentUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/02\/logo.png","width":361,"height":109,"caption":"Dynamic Web Training","name":"Dynamic Web Training Logo","description":"Dynamic Web Training official site logo asset"},"image":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DynamicWebTraining\/","https:\/\/x.com\/dynamicwebtrain"]},{"@type":"Person","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233","name":"Dynamic Web Training","image":{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","caption":"Dynamic Web Training"},"description":"This article is written by a senior writer at Dynamic Web Training. Our specialist writers are either Microsoft Certified Trainers, Adobe Certified Professionals or Certified Xero Advisors.","sameAs":["https:\/\/www.dynamicwebtraining.com.au","https:\/\/www.facebook.com\/DynamicWebTraining\/","https:\/\/www.instagram.com\/dynamicwebtraining\/","https:\/\/www.linkedin.com\/company\/dynamic-web-training","https:\/\/x.com\/dynamicwebtrain","www.youtube.com\/@dynamicwebtraining8740"],"url":"https:\/\/www.dynamicwebtraining.com.au"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#faq-question-1786060014167","position":1,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#faq-question-1786060014167","name":"What is a pivot table used for?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"A pivot table summarises a long list of data into a compact report. It groups your records and calculates totals, counts or averages, so you can quickly answer questions like total sales by region or the number of orders per customer, without writing formulas.","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#faq-question-1786060029609","position":2,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#faq-question-1786060029609","name":"How do you create a pivot table in Excel?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Click any cell in your data, go to Insert > PivotTable, and choose New Worksheet. In the PivotTable Fields pane, drag a field to Rows to group your data and a number field to Values to summarise it. Excel builds the report automatically.","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#faq-question-1786060042081","position":3,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#faq-question-1786060042081","name":"Do you need formulas to use a pivot table?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"No. A pivot table does the grouping and the calculations for you. You just drag fields into the Rows, Columns, Values and Filters areas, and Excel produces the totals, so it is ideal for people who are not confident with formulas.","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#faq-question-1786060059345","position":4,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#faq-question-1786060059345","name":"How do you refresh a pivot table?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Right-click anywhere in the pivot table and choose Refresh, or go to PivotTable Analyze > Refresh. Pivot tables do not update automatically when the source data changes. If you built it from an Excel Table, new rows are picked up on refresh.","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#faq-question-1786060072335","position":5,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#faq-question-1786060072335","name":"Why is my pivot table not updating with new data?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Two common reasons: you have not refreshed it (right-click > Refresh), or your new rows fall outside the original data range. Building the pivot table from an Excel Table (Ctrl+T) fixes this, because the range expands automatically.","inLanguage":"en-AU"},"inLanguage":"en-AU"},{"@type":"Question","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#faq-question-1786060080738","position":6,"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/excel-pivot-tables-beginners-guide#faq-question-1786060080738","name":"Can a pivot table show an average instead of a total?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Yes. Right-click a value and choose Value Field Settings, then select Average (or Count, Max, Min). The same field can show a total, a count or an average just by changing this setting.","inLanguage":"en-AU"},"inLanguage":"en-AU"}]}},"_links":{"self":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/2683","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/comments?post=2683"}],"version-history":[{"count":2,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/2683\/revisions"}],"predecessor-version":[{"id":2693,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/2683\/revisions\/2693"}],"wp:attachment":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/media?parent=2683"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/categories?post=2683"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/tags?post=2683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}