First bow and give thinks to the DemiGod of Analytics Tom Tobin (the guy who taught me "The Power of One"). Then create a new custom field on the object that you want to count in your Reports (my advice: do it on every Object in your Salesforce org).
Documentation Create Custom Fields​
Step 1. Choose the Field Type
Select: Formula
Step 2. Choose the Output Type
Select: Number (0 decimals)
*** DO NOT name the field "Power of One" ***
Step 3. Build the Formula
1
that's it, just a number one, nothing else... What??? why are you looking at me like that??? The moment you click "Save" every existing record of that Object will have a number 1 on it, no matter how many thousands, millions, bahzillions of them you have on your SFDC org, and every record that is created after that for as long as you have your SFDC org and the stars shine and the Sun burns bright. So what's the big f*ing deal??? It's just a 1... you create a Power of One field on an Account, you look at an Account and there's just a 1, what's so friggin' awesome about that??? Grab a Report and add your shiny new "Power of One" fields to it and select Summarize(SUM) Then Run the Report... *** Spoiler Alert: Here's where the magic happens ***
Now you can get the number of Opportunity Owners, the number of Accounts, the number of Opportunities, the number of Opportunity Products, Lightbulbs, Widgets, Bottles of Beer on the Wall... all using The Power of One But don't take my word for it...
