+ Reply to Thread
Results 1 to 2 of 2

Pivot Tables-To Find Count of Unique(Distinct)User id within the same Journal Entry.

  1. #1
    Registered User
    Join Date
    05-10-2010
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    34

    Pivot Tables-To Find Count of Unique(Distinct)User id within the same Journal Entry.

    Hi

    I am attaching two screen shots for a detail explaination.


    As you can see the blue lines are Entry lines which have Lines and Grlines under it(as child)

    If you see E column which has Journal Entry Number and F column which has User id column.


    And within same the Journal Entry Number column there might be different number of users with different user ids.

    Hence i have created a Pivot table for the first five columns for this case.


    The 2nd screenshot i filtered the grouping level column that has only the Lines and Grlines(No Entry level) and all the Journal Entry Numbers such as MTX-10001158,MTX-10001163 etc and all the User ids that fall under its respective Journal Entry Number.


    Here I want to know whether i can get the Distinct or Uniqe Count of the different User ids within the same Journal Entry Number column.


    Example in the 1st screenshot that has MTX-10001158 Journal Entry Number has

    USER95
    USER94
    USER95
    USER94


    in the line and grlines level.

    so i want count=2 for User id USER94
    and count = 2 for User id USER95 within the same Journal Entry using Pivot table and so on for all the Journal Entry Numbers.

    That is Distinct count of different user ids within the same Journal Entry Number using pivot table and

    if possible the sum of count of user ids distict count.(example count =2 for user94 and count for user95 is 2 so sum is 2+2=4)


    Please help me with this query.


    Thank you.
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    11-19-2010
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Pivot Tables-To Find Count of Unique(Distinct)User id within the same Journal Ent

    Hello, this should allow you to get unique count in your pivot:
    http://lazyvba.blogspot.com/2010/11/...-to-count.html

    Regards

+ 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