+ Reply to Thread
Results 1 to 4 of 4

Date, Total Count, Count broken out by Department

  1. #1
    Registered User
    Join Date
    07-28-2016
    Location
    United State
    MS-Off Ver
    2010
    Posts
    43

    Date, Total Count, Count broken out by Department

    Greeting,

    My supervisor has asked me to generate a report out of Raw Data tab in attached excel sheet that shows following: Date, Total Count, Count broken out by Department (should equal total)

    I inserted a pivot table and a formula in yellow that shows the number of employees for any given date or period of the time but could not figure out what she wanted.

    I really appreciate if I could get some help with this.

    Regards,

    Saeidian
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    5,428

    Re: Date, Total Count, Count broken out by Department

    Why then ALL the data in the pivot table?
    Attached Files Attached Files
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you ( It doesn't hurt )

  3. #3
    Registered User
    Join Date
    07-28-2016
    Location
    United State
    MS-Off Ver
    2010
    Posts
    43

    Re: Date, Total Count, Count broken out by Department

    Thank you so much!

    I came up with the Pivot Table solution but the RawData tap is the data set she provided me with.

    Regards,

    Saeid

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    5,428

    Re: Date, Total Count, Count broken out by Department

    Well, but you can play around with the pivot table and make as many combinations as you want.
    Did the layout I sent you help a little?

    You could also take a look at the user of slicers, google for that and you'll see you can accomplish a lot and all without macros
    Last edited by Keebellah; 12-18-2019 at 05:58 PM. Reason: xtra info

+ 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