Adding totals based on titles

Simon_King

hi,

 

I am trying to group together user totals based on their adjacent column title I have tried groups and cases but cant get this to work.  My latest attempt is below, can anyone help.

 

SUM(
CASE
when `PS Variable Stub`="ADenabled" or `PS Variable Stub`="O365enabled" then `GUID_ User Count`
else 0
End
)

 

Thanks

guitarhero23

You seem to have been on the right track, I didn't really need to do anything different than you did.

 

Here are my results based on your sample data

 

 

Total Active Accounts:

SUM(
  (CASE 
  WHEN `PS Variable Stub` = 'TOTALADaccounts' OR `PS Variable Stub` = 'totalO365accounts' THEN `UPN: User Count`

  ELSE 0
  END)
  )

No MFA:

SUM(
  (CASE 
  WHEN `PS Variable Stub` = 'EnabledInMFAExclude' OR `PS Variable Stub` = 'O365MFANotOnAccountRequired' OR `PS Variable Stub` = 'O365MFAExclude' OR `PS Variable Stub` = 'O365MFANotOnAccountRequired' THEN `UPN: User Count`

  ELSE 0
  END)
  )

Internet Blocked Accounts:

SUM(
  (CASE 
  WHEN `PS Variable Stub` = 'TOTALADaccounts' OR `PS Variable Stub` = 'totalO365accounts' THEN `UPN: User Count`

  ELSE 0
  END)
  )

  -

  SUM(
  (CASE 
  WHEN `PS Variable Stub` = 'EnabledInMFAExclude' OR `PS Variable Stub` = 'O365MFANotOnAccountRequired' OR `PS Variable Stub` = 'O365MFAExclude' OR `PS Variable Stub` = 'O365MFANotOnAccountRequired' THEN `UPN: User Count`

  ELSE 0
  END)
  )

  -

  SUM(
    (CASE 
    WHEN `PS Variable Stub` = 'EnabledWithMFA' THEN `UPN: User Count`
     ELSE 0
    END)
   )