+ Reply to Thread
Results 1 to 2 of 2

Distinct counts in piviot tables

  1. #1
    rqwatson
    Guest

    Distinct counts in piviot tables

    I sure need some help here.

    I was trying to count distinct occurence of transportation in the following:

    Type Status
    Car Active
    Car Active
    Car Active
    Car Decoupled
    Truck Active
    Truck Active
    Truck Decoupled
    Truck Hold
    Truck Active
    Train Hold
    Train Decoupled
    Train Active
    Train Active
    Plane Hold
    Plane Active


    But only want to show the count for active as 4; although there are 9 counts
    of active there are only 4 different distinct types.



  2. #2
    Mike Middleton
    Guest

    Re: Distinct counts in piviot tables

    rqwatson -

    Here's one way: First choose Data | Advanced Filter | Unique Records Only |
    Copy To Another Location. Then choose Data | Filter to view unique records,
    or choose Data | Pivot Table to obtain a count.

    - Mike
    www.mikemiddleton.com

    "rqwatson" <[email protected]> wrote in message
    news:[email protected]...
    >I sure need some help here.
    >
    > I was trying to count distinct occurence of transportation in the
    > following:
    >
    > Type Status
    > Car Active
    > Car Active
    > Car Active
    > Car Decoupled
    > Truck Active
    > Truck Active
    > Truck Decoupled
    > Truck Hold
    > Truck Active
    > Train Hold
    > Train Decoupled
    > Train Active
    > Train Active
    > Plane Hold
    > Plane Active
    >
    >
    > But only want to show the count for active as 4; although there are 9
    > counts of active there are only 4 different distinct types.




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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