Slight fudge on the use of Jira I suspect but ..
I want to be able to use Jira to build teams for Client work. My vision is to have each workflow (column) as an independant Client with each ticket underneath a Person. Each column (Client) should then be able to display the sum of a bespoke field(s) for example I might want to see the sum of the buy price of all people for Client A and the sum of the sell price for all people in Client A.
Ideally I should then be able to move people between clients and get a realtime update to understand what that does to costs.
Im still forming the idea in m head tbh but if Im really using the wrong tool Ill look elsewhere Excel probably .. 
Cheers