Is it possible to create a tree view that shows the following information:
_______________________________________________________________________
| Product Name | Stock Chicago | Stock Miami | Stock Boston | Total Stock |
-----------------------------------------------------------------------------------------------------------------------
| 320Gb HDD | 30.00 | 22.00 | 9.00 | 61.00 |
-----------------------------------------------------------------------------------------------------------------------
It's kind of uncomfortable going to Menu -> Reports -> inventory analysis -> Group by location every time to check stock of a product.