+ Reply to Thread
Results 1 to 2 of 2

Curious how to count 2 categories for total items in Pivot Table

  1. #1
    Registered User
    Join Date
    07-03-2014
    Location
    Pennsylvania, USA
    MS-Off Ver
    2013
    Posts
    5

    Curious how to count 2 categories for total items in Pivot Table

    I am trying to put together a report to find out how many times someone called in regarding issue (to find the top call drivers) and I want to put the results into a Pivot Table. The table has 2 columns and I'd like to count the number of times where both categories are present and treat them as 1 item. Here is a sample table:

    Category 1 Category 2
    Windows Outlook
    Linux Email
    Windows Word
    Windows Outlook
    Android Mail
    IOS Outlook

    I don't want Outlook to count as 3 items, I want Windows and Outlook to count as 2 and IOS and Outlook to count as 1. I was able to simulate this by adding a 3rd column which was always 1 and use it for the calculation but I was curious if there was a cleaner way to do this without having to add another column?

  2. #2
    Registered User
    Join Date
    07-03-2014
    Location
    Pennsylvania, USA
    MS-Off Ver
    2013
    Posts
    5

    Re: Curious how to count 2 categories for total items in Pivot Table

    Never mind, I found the answer. Needed to drag Category1 to values.

+ 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. code that will count the number of items selected in a slicer on a pivot table
    By asmi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-11-2017, 12:57 AM
  2. Pivot Table - Determining Total Count
    By chicity26 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 01-26-2017, 07:40 PM
  3. Pivot table sum of TAT/ count of items
    By Apple Ling in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-16-2017, 12:33 PM
  4. Count Multiple Items in a Pivot Table filter
    By Karen13 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-16-2015, 05:49 AM
  5. [SOLVED] How to find % of total for all the items in different categories
    By tantcu in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-17-2013, 06:39 PM
  6. [SOLVED] Grand Total of Calculated Items in a Pivot Table Incorrect
    By drstrings in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-11-2013, 11:57 AM
  7. Replies: 2
    Last Post: 09-26-2012, 01:41 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