Need assistance with Aggregate formula to calculation % of total

Need assistance with Aggregate formula to calculation % of total

Hi All -

I'm trying to create an aggregate formula to calculate percentage of total.  THe end goal is 3 columns:
1. Request Type
2. Request Count
3. Request %

I have the following whihc works if a hard code the total.

But when I try to add the SUM function, it doesn't return anything. Can anyone assist please?

            Zoho Pagesense Resources

              Zoho SalesIQ Resources



                    Zoho TeamInbox Resources

                      Zoho DataPrep Resources



                        Zoho CRM Plus Resources

                          Zoho Books Resources


                            Zoho Subscriptions Resources

                              Zoho Desk Resources

                                Zoho Projects Resources


                                  Zoho Sprints Resources


                                    Qntrl Resources


                                      Zoho Creator Resources


                                        Zoho WorkDrive Resources




                                            Zoho Campaigns Resources

                                              Zoho CRM Resources

                                                      Design. Discuss. Deliver.

                                                      Create visually engaging stories with Zoho Show.

                                                      Get Started Now


                                                        Zoho Show Resources