+ Reply to Thread
Results 1 to 5 of 5

Powerpivot...Show counts where codes tied to an account are in one group but not the other

  1. #1
    Registered User
    Join Date
    08-07-2014
    Location
    US
    MS-Off Ver
    Office 10
    Posts
    6

    Powerpivot...Show counts where codes tied to an account are in one group but not the other

    Hi I'm fairly new to PowerPivot so I'm sure one of the experts has a good answer for this.

    We have customer accounts that have service codes attached to them…i.e customer 123 could have service code 1,2,3,4,5 etc..

    What I want to do is show counts where a customer has service code(s) but doesn't have other code(s).

    For example, maybe I want to show how many active customers have service code 1 but don't have service code 4 and 5.
    Is there a simple way I can do this?

    Also I want to create this to allow for the user to choose which codes to select to compare.
    I tried using slicers but that doesn’t seem like an option.

    This should be easy to figure out I would think but I’m struggling.
    Anyone have a recommendation to point me in the right direction?

    Thanks

  2. #2
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Powerpivot...Show counts where codes tied to an account are in one group but not the o

    Pl post a sample file
    Click just below left if it helps, Boo?ath?

  3. #3
    Registered User
    Join Date
    08-07-2014
    Location
    US
    MS-Off Ver
    Office 10
    Posts
    6

    Re: Powerpivot...Show counts where codes tied to an account are in one group but not the o

    I don't have a sample file...I pretty much described what I need above, has anyone ever had to do something similar?

  4. #4
    Registered User
    Join Date
    08-07-2014
    Location
    US
    MS-Off Ver
    Office 10
    Posts
    6

    Re: Powerpivot...Show counts where codes tied to an account are in one group but not the o

    bumpitybump

  5. #5
    Registered User
    Join Date
    08-07-2014
    Location
    US
    MS-Off Ver
    Office 10
    Posts
    6

    Re: Powerpivot...Show counts where codes tied to an account are in one group but not the o

    Anyone? Bueller?

+ 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. File excel format for Mann kendall Test with tied group
    By luca71 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-20-2013, 04:19 PM
  2. Charting counts of zip codes
    By dougdrex in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-07-2013, 03:04 PM
  3. [SOLVED] Sumif of a range i.e between account codes 100 - 500
    By Hesh in forum Excel General
    Replies: 5
    Last Post: 06-18-2012, 07:10 AM
  4. Sorting account codes
    By 8RaM in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-24-2007, 03:14 PM
  5. Replies: 3
    Last Post: 02-08-2006, 08:20 AM

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