Pivot Views: Calculated fields to allow for dynamic aggregation
In the same way that pivot tables in excel or equivalents allow you to create a calculated field in your pivot view. This field would not be a calculated field in the table itself, but a calculated field that would dynamically perform a calculation function regardless of the rows and columns you set for your pivot view.
For some reference, I've provided several links for other tools like Excel, Tableau and Google Data Studio.
Thank you for reaching out! Being able to dynamically perform calculations on Pivot View values sounds like an extremely helpful feature, and this would be a great suggestion for an enhancement to our system. I have logged a ticket with our Product team for them to review and consider implementing this functionality in a future project.
Once this feature is released to the system, you will be notified via email!