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, 26 Sep 2023 12:23:52 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRUBZt1zeTpaQZNaYRWadcX6 By default, the Pivot Table shows only the items for which there is data. In the example shown in this video, not all colours were sold to each customer. You may wish to see all the items for each customer, even those items with no data. Comparing Product Sales By default, an Excel Pivot Table … Continue reading "Show All Pivot Table Items To Compare Sales Easily-No Data"]]> Thu, 14 Sep 2023 06:02:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRUBZt1zeTpaQZNaYRWadcX6 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRWpsHpKIJ8SragzzHWHxDTV If you build an Excel pivot table, and no data is entered for some items, there will be blank cells in the pivot table values area. See how to change those blanks to zero, or a text string, such as “N/A” Blank Value Cells In the pivot table screenshot below, there are two empty cells … Continue reading "Show Zero in Empty Pivot Table Value Cells"]]> Thu, 17 Aug 2023 06:01:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRWpsHpKIJ8SragzzHWHxDTV https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRVAHwII1_5XP6bel3Iu4GjH When you create a new pivot table, and add multiple fields to the row or column area, subtotals are automatically created. For Row fields the automatic subtotals usually appear at the top, and you can move them to the bottom, if that’s your preference. There are a few limitations though, which you can see in … Continue reading "Show Excel Pivot Table Subtotals Top or Bottom"]]> Thu, 20 Jul 2023 06:02:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRVAHwII1_5XP6bel3Iu4GjH https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRVdwn5VOlZYlQX50KYzL9tX You can create custom PivotTable Styles in an Excel workbook, to fine tune the appearance of your pivot tables. Later, if you want to use those custom styles in a different Excel file, you’ll have to manually copy them, using the steps shown below. Video: Copy Pivot Table Style to Different Workbook This short video … Continue reading "Copy PivotTable Format to Different Excel File"]]> Wed, 05 Jul 2023 06:01:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRVdwn5VOlZYlQX50KYzL9tX https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRUG3q3kaeZ34fnNuMIJyU22 If you make a pivot chart in Excel, you might wonder why all the columns are the same colour. The video below shows a quick fix for that pivot chart problem, and create columns in different colours. Video: Fix Pivot Chart All Columns One Color In this video’s example, the pivot chart shows sales data, … Continue reading "Fix Pivot Chart All Columns One Colour"]]> Wed, 07 Jun 2023 06:01:00 +0200 https://api.follow.it/track-rss-story-click/v3/TJt8Uv_MVRUG3q3kaeZ34fnNuMIJyU22 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