Couldn’t find a more precise name for the question.
There are projects, and as expenses are entered on account of those projects, under different ‘Heads’ such as material purchase, labor, subcontracting etc., there is a virtual column defined for each project to show the total cost incurred for the projects. Which is essentially the sum of amounts under all those ‘heads’. The column is shown on the detail view of the project.
Now I want to show the expenses under each such head. It wouldn’t have been a problem if the number of ‘heads’ was small (like within 3-4) - it only would have taken me 3-4 additional virtual columns on the detail view of the project.
But the number of such ‘heads’ is substantial, and having them all in one detail view would be a disaster for aesthetics. So what I want is to have an action that takes me to such a detail view which would show all the virtual columns and the associated expenses.
Is there any way to make a whole sheet virtual? Or any other way which can serve my purpose?
LinkedIn
Twitter
