Can i add a virtual column to get the total number of items ([category]) in my table?
I have a table - “Utilization Report”
In this table i get data that changes every minute:
[Category] - Type of item i.e. - pump
[Sub category] - Description of that item
[Total inventory] - this changes during the day as customers rent items
[Total out] - changes accordingly
[Total on Hand] - changes accordingly
My question is - how do i get a total of the column - [category]? I want to know how many pumps there are total, out, on hand. I know i can “count” in group aggregate for a table view. But i want a view to look like this:
Total Inventory | Total Out | Total On Hand
Pumps 100 | 30 | 70
4" pump 50 | 40 | 10
6" pump 25 | 20 | 5
Does this make sense?