DECLARE @Collection varchar(10)
SET @Collection = 'CM1000XX'
 
SELECT *,
(SELECT s.[Client Count] * 100 / (SELECT SUM('Client Count') FROM s) AS 'Percent %'
FROM
(
SELECT	[Software Installed], 
		Publisher, 
		Version, 
		COUNT(*) AS 'Client Count'
 
FROM(
	SELECT		Add_Remove_Programs_DATA.displayname00	as 'Software Installed', 
				Add_Remove_Programs_DATA.publisher00	as 'Publisher', 
				Add_Remove_Programs_DATA.version00		as 'Version'			
	FROM		v_R_System AS Sys
	LEFT JOIN	v_fullcollectionmembership FCM
	ON			FCM.resourceid = Sys.resourceid
	INNER JOIN	Add_Remove_Programs_DATA 
	ON			Sys.ResourceID = Add_Remove_Programs_DATA.MachineID 
	WHERE		FCM.collectionid = @Collection		
	AND			(Add_Remove_Programs_DATA.Displayname00 = 'Microsoft Office 365 ProPlus - en-us'
	OR			Add_Remove_Programs_DATA.Displayname00 LIKE 'Microsoft Office Professional%')
	AND			Add_Remove_Programs_DATA.Version00 LIKE '1%'
 
	UNION ALL
 
	SELECT  	Add_Remove_Programs_64_DATA.displayname00	as 'Software Installed', 
				Add_Remove_Programs_64_DATA.publisher00		as 'Publisher',
				Add_Remove_Programs_64_DATA.version00		as 'Version'
	FROM		v_R_System AS Sys
	LEFT JOIN	v_fullcollectionmembership FCM
				ON FCM.resourceid = Sys.resourceid
	INNER JOIN	Add_Remove_Programs_64_DATA 
	ON			Sys.ResourceID = Add_Remove_Programs_64_DATA.MachineID 
	WHERE		FCM.collectionid = @Collection		
	AND			(Add_Remove_Programs_64_DATA.Displayname00 = 'Microsoft Office 365 ProPlus - en-us'
	OR			Add_Remove_Programs_64_DATA.Displayname00 LIKE 'Microsoft Office Professional%')
	AND			Add_Remove_Programs_64_DATA.Version00 LIKE '1%') AS x64
group by Version, [Software Installed], Publisher
order by Version
)AS s

REVDTEFSRSBAQ29sbGVjdGlvbiB2YXJjaGFyKDEwKQpTRVQgQENvbGxlY3Rpb24gPSAnQ00xMDAwWFgnCgpTRUxFQ1QgKiwKKFNFTEVDVCBzLltDbGllbnQgQ291bnRdICogMTAwIC8gKFNFTEVDVCBTVU0oJ0NsaWVudCBDb3VudCcpIEZST00gcykgQVMgJ1BlcmNlbnQgJScKRlJPTQooClNFTEVDVAlbU29mdHdhcmUgSW5zdGFsbGVkXSwgCgkJUHVibGlzaGVyLCAKCQlWZXJzaW9uLCAKCQlDT1VOVCgqKSBBUyAnQ2xpZW50IENvdW50JwoKRlJPTSgKCVNFTEVDVAkJQWRkX1JlbW92ZV9Qcm9ncmFtc19EQVRBLmRpc3BsYXluYW1lMDAJYXMgJ1NvZnR3YXJlIEluc3RhbGxlZCcsIAoJCQkJQWRkX1JlbW92ZV9Qcm9ncmFtc19EQVRBLnB1Ymxpc2hlcjAwCWFzICdQdWJsaXNoZXInLCAKCQkJCUFkZF9SZW1vdmVfUHJvZ3JhbXNfREFUQS52ZXJzaW9uMDAJCWFzICdWZXJzaW9uJwkJCQoJRlJPTQkJdl9SX1N5c3RlbSBBUyBTeXMKCUxFRlQgSk9JTgl2X2Z1bGxjb2xsZWN0aW9ubWVtYmVyc2hpcCBGQ00KCU9OCQkJRkNNLnJlc291cmNlaWQgPSBTeXMucmVzb3VyY2VpZAoJSU5ORVIgSk9JTglBZGRfUmVtb3ZlX1Byb2dyYW1zX0RBVEEgCglPTgkJCVN5cy5SZXNvdXJjZUlEID0gQWRkX1JlbW92ZV9Qcm9ncmFtc19EQVRBLk1hY2hpbmVJRCAKCVdIRVJFCQlGQ00uY29sbGVjdGlvbmlkID0gQENvbGxlY3Rpb24JCQoJQU5ECQkJKEFkZF9SZW1vdmVfUHJvZ3JhbXNfREFUQS5EaXNwbGF5bmFtZTAwID0gJ01pY3Jvc29mdCBPZmZpY2UgMzY1IFByb1BsdXMgLSBlbi11cycKCU9SCQkJQWRkX1JlbW92ZV9Qcm9ncmFtc19EQVRBLkRpc3BsYXluYW1lMDAgTElLRSAnTWljcm9zb2Z0IE9mZmljZSBQcm9mZXNzaW9uYWwlJykKCUFORAkJCUFkZF9SZW1vdmVfUHJvZ3JhbXNfREFUQS5WZXJzaW9uMDAgTElLRSAnMSUnCgoJVU5JT04gQUxMCgoJU0VMRUNUICAJQWRkX1JlbW92ZV9Qcm9ncmFtc182NF9EQVRBLmRpc3BsYXluYW1lMDAJYXMgJ1NvZnR3YXJlIEluc3RhbGxlZCcsIAoJCQkJQWRkX1JlbW92ZV9Qcm9ncmFtc182NF9EQVRBLnB1Ymxpc2hlcjAwCQlhcyAnUHVibGlzaGVyJywKCQkJCUFkZF9SZW1vdmVfUHJvZ3JhbXNfNjRfREFUQS52ZXJzaW9uMDAJCWFzICdWZXJzaW9uJwoJRlJPTQkJdl9SX1N5c3RlbSBBUyBTeXMKCUxFRlQgSk9JTgl2X2Z1bGxjb2xsZWN0aW9ubWVtYmVyc2hpcCBGQ00KCQkJCU9OIEZDTS5yZXNvdXJjZWlkID0gU3lzLnJlc291cmNlaWQKCUlOTkVSIEpPSU4JQWRkX1JlbW92ZV9Qcm9ncmFtc182NF9EQVRBIAoJT04JCQlTeXMuUmVzb3VyY2VJRCA9IEFkZF9SZW1vdmVfUHJvZ3JhbXNfNjRfREFUQS5NYWNoaW5lSUQgCglXSEVSRQkJRkNNLmNvbGxlY3Rpb25pZCA9IEBDb2xsZWN0aW9uCQkKCUFORAkJCShBZGRfUmVtb3ZlX1Byb2dyYW1zXzY0X0RBVEEuRGlzcGxheW5hbWUwMCA9ICdNaWNyb3NvZnQgT2ZmaWNlIDM2NSBQcm9QbHVzIC0gZW4tdXMnCglPUgkJCUFkZF9SZW1vdmVfUHJvZ3JhbXNfNjRfREFUQS5EaXNwbGF5bmFtZTAwIExJS0UgJ01pY3Jvc29mdCBPZmZpY2UgUHJvZmVzc2lvbmFsJScpCglBTkQJCQlBZGRfUmVtb3ZlX1Byb2dyYW1zXzY0X0RBVEEuVmVyc2lvbjAwIExJS0UgJzElJykgQVMgeDY0Cmdyb3VwIGJ5IFZlcnNpb24sIFtTb2Z0d2FyZSBJbnN0YWxsZWRdLCBQdWJsaXNoZXIKb3JkZXIgYnkgVmVyc2lvbgopQVMgcw==