I have a “Projects” table in which I intend to incorporate virtual columns that sum the amount of money spent on a number of aspects, namely suppliers, contractors, users and a few more.
While I have the knowledge now how to use the SELECT() expression and compute the SUM of amounts spent on those aspects for each project, what I don’t know and think would be good to implement is that ‘nesting’ all those aspects under a “Total” tab.
The ‘total tab’, mathematically is just an arithmetic sum of all those ‘aspects’. What I want is a drop-down in the ‘total’ column which when tapped, drops down a menu with all the aspects and their associated expenses accumulated. All the columns would be virtual, with select() and sum() expressions within.