Here is a screenshot for visual assistance:
I want to be able to pull the logins for just March, June, and July while leaving the 341 who have never logged on as a percentage. To grab the percentages you see above, I used "RowCount/PARENTGROUPVAL(RowCount, ROW_GRAND_SUMMARY, COLUMN_GRAND_SUMMARY)" as my formula. Please let me know how I pull just the specified months where there were logins. I appreciate it!
here's the formula with your API name.
Be sure to :
1: Create the text formula field on the contact record
2) Make sure Vault_Login_Created__c is of type Date
(not datetime or text, etc) if Datetime, using the formula at the bottom.
Thxif Vault_Login_Created__c is a date
CASE( MONTH(Vault_Login_Created__c),
1,"January " + Text(Year(Vault_Login_Created__c)),
2,"February "+ Text(Year(Vault_Login_Created__c)),
3,"March "+ Text(Year(Vault_Login_Created__c)),
4,"April "+ Text(Year(Vault_Login_Created__c)),
5,"May "+ Text(Year(Vault_Login_Created__c)),
6,"June "+ Text(Year(Vault_Login_Created__c)),
7,"July "+ Text(Year(Vault_Login_Created__c)),
8,"August "+ Text(Year(Vault_Login_Created__c)),
9,"September "+ Text(Year(Vault_Login_Created__c)),
10,"October "+ Text(Year(Vault_Login_Created__c)),
11,"November "+ Text(Year(Vault_Login_Created__c)),
12,"December "+ Text(Year(Vault_Login_Created__c)),
"Non Successful Logins"
)
If the Vault_Login_Created__c type is datetime use this:CASE( MONTH(DATEVALUE(Vault_Login_Created__c)),
1,"January " + Text(Year(DATEVALUE(Vault_Login_Created__c))),
2,"February "+ Text(Year(DATEVALUE(Vault_Login_Created__c))),
3,"March "+ Text(Year(DATEVALUE(Vault_Login_Created__c))),
4,"April "+ Text(Year(DATEVALUE(Vault_Login_Created__c))),
5,"May "+ Text(Year(DATEVALUE(Vault_Login_Created__c))),
6,"June "+ Text(Year(DATEVALUE(Vault_Login_Created__c))),
7,"July "+ Text(Year(DATEVALUE(Vault_Login_Created__c))),
8,"August "+ Text(Year(DATEVALUE(Vault_Login_Created__c))),
9,"September "+ Text(Year(DATEVALUE(Vault_Login_Created__c))),
10,"October "+ Text(Year(DATEVALUE(Vault_Login_Created__c))),
11,"November "+ Text(Year(DATEVALUE(Vault_Login_Created__c))),
12,"December "+ Text(Year(DATEVALUE(Vault_Login_Created__c))),
"Non Successful Logins"
)