+ Reply to Thread
Results 1 to 2 of 2

Remove duplicate counts in pivot table

  1. #1
    Registered User
    Join Date
    08-01-2023
    Location
    Minneapolis, MN
    MS-Off Ver
    2016
    Posts
    1

    Remove duplicate counts in pivot table

    Hi! I'm trying to remove duplicate counts in my pivot tables. My PT include filters (1-2 items), columns (1-2 items), rows (2-3 items) and values (counts). For the main row there are bold counts and then in the secondary rows there counts as well. What can I do to hide/not count the secondary level of rows? In other words, I don't want a one there. I want it blank. Please see attached sample data and highlighted secondary rows, I'd like to make blank. Thanks so much!

  2. #2
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    217

    Re: Remove duplicate counts in pivot table

    You request makes no sense. You are showing secondary rows, so you get counts on those rows. If you don't want double counts, then remove subtotals and grand totals:

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How can I remove the duplicate numbering for the headers in a pivot table?
    By Rob - Jedco in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 01-29-2024, 10:11 PM
  2. [SOLVED] Formula or Pivot Table or something else to remove duplicate entries
    By dgrissom in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-24-2022, 10:29 PM
  3. [SOLVED] Counts using pivot table
    By luckysingh in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-01-2019, 10:13 PM
  4. [SOLVED] Subtracting one sum of counts from another sum of counts in a pivot table
    By steve78 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-07-2019, 01:35 PM
  5. How to sum counts from a certain pivot table
    By Horrid Wilting in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-06-2018, 03:21 AM
  6. Replies: 2
    Last Post: 05-08-2013, 04:56 PM
  7. [SOLVED] Remove Duplicate Budget Amounts within the Pivot Table
    By mhedge in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-02-2013, 03:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1