+ Reply to Thread
Results 1 to 2 of 2

Pivot Average of Count

  1. #1
    Registered User
    Join Date
    06-25-2011
    Location
    Chicago, IL
    MS-Off Ver
    MS 365 apps for business
    Posts
    63

    Pivot Average of Count

    Hi All,

    How you do an average of the count in a Pivot Table? I know how to do the average, but how do you do the average of the count? For instance, in one piece of my data I want to know what is the average Inpatient level for CT at 1am on a Sunday. I get the count to say there were 8 throughout my data-set, but across all of the Sundays in the data, what was the average? Sorry, my file is much too large to upload. Any help is appreciated. Thanks.
    Last edited by zpenacho; 02-14-2012 at 01:48 PM.

  2. #2
    Registered User
    Join Date
    06-25-2011
    Location
    Chicago, IL
    MS-Off Ver
    MS 365 apps for business
    Posts
    63

    Re: Pivot Average of Count

    It requires a calculated field, for all those interested.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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