Hello,

I am creating a saved search from a custom record which will count active customers and grouped by location. I already have the Criteria but on the Results, I need to show the count of active customers Beginning last month then End of last month and eventually calculating the increased no. of customers.

Results should be something like this:

Location (Grouped)
Count beginning last month
Count end of last month
Net increase
                       
                  Beginning of last month    End of last month    Net increase           
Location1            XX                             XX+YY                  +YY                  
Location2            XY                             XY+YZ                  +YZ

Any help will be highly appreciated. Thank you!