I don't know how to solve this problem, please help me and I will rate you later

^ ^ thank you!

AutoSave Off PB Sample BI File Home Insert Page Layout Formulas Data Review View Tell me what you want to do X Calibri - 11 AA ale Wrap Text General TIX LA- Paste BIU- A. Merge & Center - $ -% -28 Cell Styles Conditional Format as Formatting Table Styles Insert Delete Clipboard Font Alignment Number Cells 118 B D F G H J K L M 16 Precision Building 1 2 Task Instructions 4 Last Name Insert subtotals, using the Sum function, for each category in the State field, sorted A to Z in range A4:D19. The subtotals should add the values in the Workshops Attended field for each State category, and then include a grand total. 5 Long 6 Handley 7 Riehle 8 Kawada 9 Robins 10 Nunn 11 Lopez 12 Wilcox 13 Allu 14 O'Donnell 15 Ayers 16 George 17 Han 18 Andrade 19 Gage Workshop Participants Workshops First Name State Attended Stephan GA 5 Miriam TN 4 Paul GA 5 Carolyn GA 2 Jayden TN 1 LaShonda TN 1 Marcella TN 1 Evelynn GA 4 Sarji GA 3 Danny GA 1 Stan GA 1 Lawrence GA 5 Hyo Jin GA 2 Salina GA 3 James GA 2 20 21 22 23