Formatting Numbers for the Total Row / First Row only

Anonymous Thank you so much for looking into this, I have been playing around with the sample file you provided and applying what you did to my own file, so far, no luck on getting what I want.

I understand without taking a look at the dataset and visuals I have, it is very hard to answer my questions, I am working on cleaning and masking my data and would like to provide a sample of my real file here. If you can take a second look at it at that time, that would be much appreciated!!

I am also wondering if there is Microsoft Support available for this kind of issue, I have access to "Professional Direct" level support for Power Platform at work, I am wondering if this is something I can open a ticket with Microsoft under the "Advisory Support" feature?