Spreadsheet: 867443d1714300720-how-to-summarise-dependent-totals-on-a-single-data-set-sample-275-aligw
Sheet: Sheet1

samAccountName | DistinguishedName | OU | CanonicalName | UserPrincipalName | Name | EmployeeID | EmployeeNumber | EmailAddress | Description | AdminDescription | AdminDisplayName | Guid | Sid | SidHistory | userAccountControl | PrincipalsAllowedToDelegateToAccount | msds-SupportedEncyptionTypes | msExchHideFromAddressLists | isCriticalSystemObject | Script | HomeDirectory | Disabled | LockedOut | PasswordExpired | PasswordNeverExpires | PasswordNotRequired | TrustedForDelegation | TrustedToAuthForDelegation | DoesNotRequirePreAuth | AccountNotDelegated | AllowReversiblePasswordEncryption | Normal_Account | CannotChangePassword | UseDESKeyOnly | whenCreated | whenChanged | accountExpires | LogonCount | BadLogonCount | badPasswordTime | badPwdCount | lockoutTime | LastLogonDate | PasswordLastSet | AccountLockoutTime | [NAME] | DisplayName | Title | Manager | Department | Division | Company | Organization | Office | StreetAddress | City | Country | PostalCode | MobilePhone | OfficePhone
cluster | CN=cluster,OU=IT,OU=New Users,DC=europe,DC=contoso,DC=local | OU=SERVICE Accounts,OU=IT,OU=New Users |  |  |  |  |  |  | Cluster Service Account |  |  | 0f182723-644b-434c-9568-d0935e6cd9ec |  |  | 66048 |  |  |  |  | False | False | False | False | False | True | False | False | False | False | False | False | True | False | False | 2003-05-09 11:41:46 | 2024-02-05 14:41:52 | 9.22337203685477e+18 |  |  |  |  | 1.30881666978706e+17 | 2013-04-22 22:43:44 | 2020-03-20 02:24:18 | 2015-10-01 10:51:37
agpm | CN=agmp,OU=IT,OU=New Users,DC=europe,DC=contoso,DC=local | OU=SERVICE Accounts,OU=IT,OU=New Users |  |  |  |  |  |  | AGPM Acct |  |  | f26096c5-cdc5-4c19-aab2-58524acbc505 |  |  | 66048 |  |  |  |  | False | False | False | False | False | True | False | False | False | False | False | False | True | False | False | 2017-01-17 14:23:50 | 2024-04-17 10:29:02 | 9.22337203685477e+18 |  |  |  |  | 0 | 2024-04-17 11:08:42 | 2023-09-19 15:47:49
test | CN=test,OU=Admin Accounts,OU=IT,OU=New Users,DC=europe,DC=contoso,DC=local | OU=Admin Accounts,OU=IT,OU=New Users |  |  |  |  |  |  | Wintel |  |  | cb0b1fcd-f104-4524-a0fb-5a77434199dc |  |  | 512 |  |  |  |  | False | False | False | False | False | False | False | False | False | False | False | False | True | False | False | 2023-01-11 15:19:24 | 2024-04-16 08:44:03 | 9.22337203685477e+18 | 114 |  | 1.33457375099225e+17 | 0 |  | 2024-04-16 09:43:56 | 2023-01-11 15:19:24 |  | 2023-11-29 13:18:29
[NAME] | CN=Robert,OU=Admin Accounts,OU=IT,OU=New Users,DC=europe,DC=contoso,DC=local | OU=Admin Accounts,OU=IT,OU=New Users |  |  |  |  |  |  | Security Engineering Lead |  |  | 33d635de-3fff-4d86-9336-b2d876a2558e |  |  | 512 |  |  |  |  | False | False | False | False | False | False | False | False | False | False | False | False | True | False | False | 2020-03-12 13:29:16 | 2024-04-15 08:14:00 | 9.22337203685477e+18 | 20 |  | 1.33457201052213e+17 | 0 |  | 2024-04-15 08:52:59 | 2020-03-27 12:57:35 |  | 2023-11-29 08:28:25
Mark | CN=Mark,OU=Admin Accounts,OU=IT,OU=New Users,DC=europe,DC=contoso,DC=local | OU=Admin Accounts,OU=IT,OU=New Users |  |  |  |  |  |  | Product Technical Architect |  |  | 779d37ea-0c96-4d8c-9b74-5e4e3a94db7f |  |  | 512 |  |  |  |  | False | False | False | False | False | False | False | False | False | False | False | False | True | False | False | 2021-01-31 17:15:51 | 2024-03-26 12:07:46 | 9.22337203685477e+18 | 5 |  |  |  | 0 | 2024-03-26 12:07:41 | 2021-08-20 14:23:38
userID | CN=userID,OU=SERVICE Accounts,OU=IT,OU=New Users,DC=europe,DC=contoso,DC=local | OU=SERVICE Accounts,OU=IT,OU=New Users |  |  |  |  |  |  | Tester |  |  | [NAME] |  |  | 66048 |  |  |  |  | False | False | False | False | False | True | False | False | False | False | False | False | True | False | False | 2019-07-11 13:56:50 | 2024-04-18 18:59:07 | 9.22337203685477e+18 |  |  |  |  |  | 2024-04-18 19:52:13 | 2020-03-25 12:50:07
Connector | CN=Connector,OU=SERVICE Accounts,OU=IT,OU=New Users,DC=europe,DC=contoso,DC=local | OU=SERVICE Accounts,OU=IT,OU=New Users |  |  |  |  |  |  | DNS Service |  |  | 2b79ab27-effa-487e-bfde-dc231a2a5821 |  |  | 66048 |  |  |  |  | False | False | False | False | False | True | False | False | False | False | False | False | True | False | False | 2023-01-30 13:35:13 | 2024-04-21 14:36:10 | 9.22337203685477e+18 |  |  |  |  |  | 2024-04-21 15:36:04 | 2023-01-30 13:35:13
XEZDTPlSOi | CN=XEZDTPlSOi,OU=Prod2,OU=ADH,OU=New Servers,DC=europe,DC=contoso,DC=local | OU=Prod2,OU=ADH,OU=New Servers |  |  |  |  |  |  | Data Hub |  |  | 0c90a121-ca8d-4dce-921e-f8ab3a7ad516 |  |  | 66048 |  |  |  |  | False | False | False | False | False | True | False | False | False | False | False | False | True | False | False | 2024-01-15 14:21:13 | 2024-04-20 04:34:07 | 0 | 22 |  |  |  |  | 2024-04-20 05:34:07 | 2024-01-15 14:21:13
FZgReoMFVP | CN=FZgReoMFVP,OU=Prod2,OU=ADH,OU=New Servers,DC=europe,DC=contoso,DC=local | OU=Prod2,OU=ADH,OU=New Servers |  |  |  |  |  |  | Data Hub |  |  | 34cd3ea4-7269-4561-a291-d17cef6e7c64 |  |  | 66048 |  |  |  |  | False | False | False | False | False | True | False | False | False | False | False | False | True | False | False | 2024-01-15 14:21:14 | 2024-04-14 21:59:00 | 0 | 38 |  |  |  |  | 2024-04-14 22:44:04 | 2024-01-15 14:21:14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REQ0225274
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CN=[NAME],OU=TCS,OU=Windows 7 Laptop Users,OU=Workplace,DC=europe,DC=contoso,DC=local | Techbar |  | TCS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Software Development |  | Sopra