Hoping someone can help me out with a grand total summary that will take the subtotal average goal (this is a formula looking at the user record with their goal amount) for each rep and provide a grand total SUM of each average.
On top of that, I want to sum the subtotal (adding the average amount for each rep) to sum of those averages on the Grand Total.
Hope that makes sense and HOPE you guys can help out!
Appreciate it!
1 answer
Hi Kirk,
Sorry for the inconvenience. In case you don't receive a response here, may I also suggest joining the
Reports & Dashboards group below to collaborate with the experts for best practice and advice.
https://success.salesforce.com/_ui/core/chatter/groups/GroupProfilePage?g=0F9300000001rDKCAY
Hope this helps.
Regards,
Jayson
