Hi Laflet ,
If you want a zero-code solution, advanced UI features, and data manipulations on your pivots, I highly recommend checking out Paldi's Expandable Pivot plugin.
With the above in mind, I would say that what you are looking for can be achieved by a custom script as well.
Moreover, most UI adjustments can be done with JS script, and if this is the path you intend to go, please let me know and I will assist you.
Worth mentioning that using scripts for customizations might be inconvenient if you use them frequently because you can lose control of which dashboards and widgets have scripts applied, not to mention future migrations, etc.
I would highly recommend you look for a tool that will help you to manage all scripts applied such as the "widget script manager" plugin where you can manage the code from a single centralized place.
Feel free to reach out for free trials, we're always happy to help (: