function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Sindhuja SundarasudhanSindhuja Sundarasudhan 

The 'Top Volunteer Organizations' report is not sorting by the correct field.

Can anyone help me with this?User-added image
Best Answer chosen by Sindhuja Sundarasudhan
PriyaPriya (Salesforce Developers) 
Hi sindhuja,

Please follow below

Create a report with Report type as "Users with Volunteer Shift Worker Records".
 
Your report must include the below columns:
 
Volunteer Organisation
 
Shift Hours (Note - This displays the records with SUM by default)
 
Step 1: Group by rows in 'Volunteer Organisation'
 
Step 2: Click on the arrow besides 'Volunteer Organisation' and select Sort by "Sum of Shift Hours" (This will display data as per sum of shift hours in ascending order)
 
Step 3: Click on the arrow besides 'Volunteer Organisation and select "Sort Descending" option.
 
P.S Ensure details, row counts and sub totals are off.
 
Hope this helps! 

Kindly mark it as the best answer if it helps.

Regards,
Ranjan

All Answers

PriyaPriya (Salesforce Developers) 
Hi sindhuja,

Please follow below

Create a report with Report type as "Users with Volunteer Shift Worker Records".
 
Your report must include the below columns:
 
Volunteer Organisation
 
Shift Hours (Note - This displays the records with SUM by default)
 
Step 1: Group by rows in 'Volunteer Organisation'
 
Step 2: Click on the arrow besides 'Volunteer Organisation' and select Sort by "Sum of Shift Hours" (This will display data as per sum of shift hours in ascending order)
 
Step 3: Click on the arrow besides 'Volunteer Organisation and select "Sort Descending" option.
 
P.S Ensure details, row counts and sub totals are off.
 
Hope this helps! 

Kindly mark it as the best answer if it helps.

Regards,
Ranjan
This was selected as the best answer
cigage 6838cigage 6838
Wendy’s Breakfast Menu 2022
Dan Pearce 20Dan Pearce 20
Ive done everything above, and now get this error:

Challenge Not yet complete... here's what's wrong:
The 'Top Volunteer Organizations' report is using the incorrect custom report type.

Any help would be great
Maxime BurelleMaxime Burelle
Hi,

I'm getting the same error here. The solution given by Priya does not fix the issue here because it is ask to use the report type Accounts with Vol Activities with Vol Jobs. 
 
Here's what i've got :

 User-added imageUser-added image

Can someone help me with that?

Thanks!
GWP DulanjaliGWP Dulanjali
Hi Maxime,

You can group by rows in Account Name only. Then your error will be resovle.