Follow Excel Pivot Tables, filter it, and define how you want to receive the news (via Email, RSS, Telegram, WhatsApp etc.) https://follow.it/excel-pivot-tables Tue, 30 May 2023 20:38:56 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRXGFkad8kBZTwpx5_w21kha After you set up a pivot table, you might want to discourage people from filtering the pivot fields, which could hide some of the data. This video shows a couple of ways hide the drop down arrows in the pivot table headings. Change a Pivot Table Setting Here’s first way to hide the heading arrows. … Continue reading "Hide Drop-Down Arrows in Excel Pivot Table"]]> Wed, 24 May 2023 06:02:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRXGFkad8kBZTwpx5_w21kha https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRW83atG5oZHZOGkz6RCC25z A pivot table calculated field always uses the SUM of other values, even if those values are displayed with another summary function, such as COUNT. That can cause results that look wrong, but the video below shows a workaround to fix the problem. Pivot Table Calculated Field Problem In this example, the pivot table shows … Continue reading "Pivot Table Calculated Field Counting Problem"]]> Wed, 10 May 2023 06:02:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRW83atG5oZHZOGkz6RCC25z https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRVi4SIC756pxJNaYRWadcX6 The step-by-step video below shows how to unpivot data in Excel, using Power Query. This creates better source data that you can use to build flexible pivot tables. And this technique doesn’t change your original data! Why Unpivot Excel Data? Before you can build a flexible pivot table in Excel, you might need to rearrange … Continue reading "How to Unpivot Excel Data with Power Query"]]> Wed, 26 Apr 2023 06:02:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRVi4SIC756pxJNaYRWadcX6 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRX2OEmPGjDNVc4HQhe4ZUzd Pivot tables are a quick way to summarize your data, and they have another advantage too. After you build the pivot table, it’s easy to change the pivot table layout, to get a different type of summary. Watch the two videos below, to see a few examples. Try Different Pivot Layouts Pivot tables help you … Continue reading "Don’t Get Stuck in a Pivot Table Rut"]]> Wed, 12 Apr 2023 06:02:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRX2OEmPGjDNVc4HQhe4ZUzd https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRX18OblhJdgcXHnycKeoCpf Do you love the Excel GetPivotData formula, that appears automatically, when you click on a pivot table value? Or do you want to know how to turn that annoying setting off? In the two videos below, see how to turn GetPivotData off or on, and see an enhanced formula, that pulls data from a specific … Continue reading "Excel GetPivotData Formula Love It or Turn It Off"]]> Wed, 29 Mar 2023 06:01:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRX18OblhJdgcXHnycKeoCpf https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRWk4QgeauXAK31d0VB8z-7c Instead of writing complicated MIN IF or MAX IF formulas in Excel, you can quickly get those numbers in a pivot table. See the easy steps in the video below. Video: Show MIN IF or MAX IF in Pivot Table When you’re working with Excel data, a pivot table makes it easy to find the … Continue reading "Show MIN IF or MAXIF With Excel Pivot Table"]]> Wed, 15 Mar 2023 06:01:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRWk4QgeauXAK31d0VB8z-7c https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRXWv4jx7irTMB-xWH3zZqEA If you show pivot table subtotals for a date field, the dates might be in a format that is different from the other dates in that field. See why that happens, and how you can avoid the date format problem. Video: Fix Date Format in Pivot Table Subtotals If you add subtotals to a pivot … Continue reading "Fix Date Format in Pivot Table Subtotals"]]> Wed, 08 Mar 2023 07:02:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRXWv4jx7irTMB-xWH3zZqEA https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRUOFZFDb-NZeAm0QkxGtqLL When you create an Excel pivot table, and add values, the value fields are automatically arranged in a horizontal layout, with the headings across the top of the pivot table. To create a narrower, taller pivot table, you can move the Values, so they’re listed vertically. Watch the short video below, to see the steps. … Continue reading "Move Pivot Table Value Fields – Vertical Layout"]]> Wed, 01 Mar 2023 07:01:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRUOFZFDb-NZeAm0QkxGtqLL https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRV5y1mwlAUhj93hDS9njgCr If you’re working with an Excel pivot table, you might want to select a specific section, such as the subtotals, so you can apply formatting. The short video below has a few pivot table selection tips. Video: Select Specific Parts of Pivot Table Do you want to select one or two subtotal lines in a … Continue reading "How to Select Specific Part of an Excel Pivot Table"]]> Wed, 22 Feb 2023 07:02:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRV5y1mwlAUhj93hDS9njgCr https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRXAuUFPDxGfjN6jHbRcHw3s Excel pivot tables don’t show hyperlinks, but there’s a way around that problem! In the video below, you’ll see how to create fake clickable hyperlinks in a pivot table, by using a few lines of Excel VBA code, and a bit of formatting. No Hyperlinks in Pivot Table Unfortunately, even if there are valid hyperlinks … Continue reading "Add Clickable Hyperlinks-Excel Pivot Table-Macro Code"]]> Wed, 15 Feb 2023 07:01:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRXAuUFPDxGfjN6jHbRcHw3s https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRWUXf80Rg2CMCxhxzpi7FpJ Pivot tables are great for summarizing data, but do you ever notice that there are missing items in a pivot table? For example, you know there are customer records in the source data table, but one customer isn’t showing up in the pivot table. How can you troubleshoot and fix the problem to show all … Continue reading "Pivot Table Not Showing All Data Problem-Layout Fix"]]> Wed, 08 Feb 2023 07:02:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRWUXf80Rg2CMCxhxzpi7FpJ https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRVTtB1ohd3qOzHgrmwRGUK6 In an Excel pivot table, subtotals are automatically added to the outer fields, when you add more fields below them. You can also add extra subtotals, if needed, by creating custom subtotals for a pivot field. There are some limitations though, which you can see in the video and notes below. Video: Pivot Table Custom … Continue reading "Excel Pivot Table Custom Subtotal Limitations"]]> Wed, 25 Jan 2023 07:01:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRVTtB1ohd3qOzHgrmwRGUK6 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRVg2vkXRNdLnGW0GqTRQSgk If Excel error messages appear when you try to refresh a pivot table, there are macros on my Contextures site that can help you troubleshoot those problems. I’ve just added another macro on that page, to show a pop-up message with details, if a specific pivot table is behaving badly. Pivot Table Detail Lists Most … Continue reading "Troubleshoot Pivot Table Problems – Pop-up Info Message"]]> Wed, 11 Jan 2023 07:01:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRVg2vkXRNdLnGW0GqTRQSgk https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRU1X29QWKy4AQBC78OgjhDM After you build an Excel pivot table, you might see a few row labels or column labels that contain the text “(blank)”. This happens when data is missing from the source data. For example, in the source data, you might have a few sales orders that don’t have a Store number entered. Video: Fix Pivot … Continue reading "Fix Pivot Table Row Heading Cells Blank Label"]]> Wed, 07 Dec 2022 07:01:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRU1X29QWKy4AQBC78OgjhDM https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRVOkWif88D4khtLdxSOwF-n It’s November, a month when we expect cooler temperatures here in Canada. However, it was more like summer last weekend, and we enjoyed an afternoon beverage on the patio. Was that normal? What were the November temperatures over the past few years? Let’s use a pivot table with conditional formatting, to find out! Get the … Continue reading "Conditional Formatting Excel Pivot Table Color Scale"]]> Wed, 09 Nov 2022 07:01:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRVOkWif88D4khtLdxSOwF-n https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRX7csraddSbsa7VFky8BpXO Excel automatically adds grand totals to a pivot table, if there are multiple items in the row area, or in the column area. See how you can change the automatic grand total headings (sometimes), and quickly remove grand totals if you don’t need them. Change Grand Total Headings Most of the time, the automatic heading … Continue reading "Pivot Table Grand Totals Tips and Tricks"]]> Wed, 14 Sep 2022 06:02:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRX7csraddSbsa7VFky8BpXO https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRWxcoMkjWy7ooMOI2eu70Rg After you create a pivot table in Excel, you can filter the data, to focus on specific things. Maybe you want a top product report, or a regional summary, or see the sales to a couple of new customers. You can also use filters on date fields, and there are 3 different types you can … Continue reading "Pivot Table Date Field Filters – 3 Types to Try"]]> Wed, 03 Aug 2022 06:01:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRWxcoMkjWy7ooMOI2eu70Rg https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRV4bj2fBLxdyAVLTsI7B9NX Quickly check your sales results over time, or by top products, with the % Running Total feature in an Excel pivot table. This feature is available in Excel 2010, and later versions. Sales Progress by Month There’s a built-in pivot table feature – % Running Total – that makes it easy to see how your … Continue reading "Check Sales Progress with Percent Running Total in Excel Pivot Table"]]> Wed, 06 Jul 2022 06:02:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRV4bj2fBLxdyAVLTsI7B9NX https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRUFHtGUUNwGDAm0QkxGtqLL Excel doesn’t have a Cluster Stack chart type, but you can make a pivot chart with stacked columns that are grouped into “clusters”. See the steps in the video below, and get the sample Excel file, to try it for yourself. Excel Clustered Stacked Chart A cluster stack chart has clusters of columns or bars, … Continue reading "Easy Steps for Excel Clustered Stacked Pivot Chart"]]> Wed, 08 Jun 2022 06:02:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRUFHtGUUNwGDAm0QkxGtqLL https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRUDpnJkTJqWj2Fk24e89-qg When you set up a pivot table, and put fields into the Rows Area or Columns area, Excel groups the items, and calculates the totals for each group. For example, see count of products for each Unit Price. Each item should only be listed once in the pivot table, but sometimes you might see duplicates. … Continue reading "Duplicate Numbers in Pivot Table Items Problem"]]> Wed, 11 May 2022 06:01:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRUDpnJkTJqWj2Fk24e89-qg