# Subtotal and Stack Rank **URL:** \ **Category:** Ask the Community\ **Created:** [February 7, 2018, 4:15pm UTC](https://pug.phocassoftware.com/t/subtotal-and-stack-rank/499 "2018-02-07T16:15:46Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![JDogg016](https://avatars.discourse-cdn.com/v4/letter/j/eb9ed0/32.png) [@JDogg016](https://pug.phocassoftware.com/u/JDogg016)\ **Post date:** [February 7, 2018, 4:15pm UTC](https://pug.phocassoftware.com/t/subtotal-and-stack-rank/499/1 "2018-02-07T16:15:46Z")
Is it possible to subtotal based upon a dimension within Phocas. See the scan of a printed excel sheet with the bracketed/highlighted rows, but the goal would be to total data for a single dimension (ie. branch) and then subtotal that data by a second dimension (area manager) and have the subtotals appear within the phocas favorite. ![24%20AM](https://us1.discourse-cdn.com/flex015/uploads/phocassoftware/original/1X/fc06a2e8eb09411d4320f03269fea21383d5c5a3.png) ---
**Author:** ![tom.falter](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/tom.falter/32/165_2.png) [@tom.falter](https://pug.phocassoftware.com/u/tom.falter)\ **Post date:** [February 7, 2018, 4:28pm UTC](https://pug.phocassoftware.com/t/subtotal-and-stack-rank/499/2 "2018-02-07T16:28:09Z")
@JDogg016 - maybe something a little like this? ![Nest_Capture](https://us1.discourse-cdn.com/flex015/uploads/phocassoftware/original/1X/8620643a36398283da518e9f0a18049e0a95b2eb.png) This is our new Grid Nesting feature in 7.3.x - a great new way to work the data. ---
**Author:** ![JDogg016](https://avatars.discourse-cdn.com/v4/letter/j/eb9ed0/32.png) [@JDogg016](https://pug.phocassoftware.com/u/JDogg016)\ **Post date:** [February 7, 2018, 6:49pm UTC](https://pug.phocassoftware.com/t/subtotal-and-stack-rank/499/3 "2018-02-07T18:49:53Z")
Brilliant! But now I have to re-arrange all my budgets and how my data flows to get EXACTLY what I want. But when I do 🙂 ---
**Author:** ![telam](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/telam/32/120_2.png) [@telam](https://pug.phocassoftware.com/u/telam)\ **Post date:** [February 8, 2018, 3:06pm UTC](https://pug.phocassoftware.com/t/subtotal-and-stack-rank/499/4 "2018-02-08T15:06:13Z")
Any way to resize the columns when creating reports? Not just on this new view, but on all reports. ---
**Author:** ![ShaneAngel](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/shaneangel/32/68_2.png) [@ShaneAngel](https://pug.phocassoftware.com/u/ShaneAngel)\ **Post date:** [February 12, 2018, 12:14am UTC](https://pug.phocassoftware.com/t/subtotal-and-stack-rank/499/5 "2018-02-12T00:14:33Z")
The columns should “fit” the window you have the browser open in, so it works across all devices seamlessly, however, since the latest update I have noticed some columns are not resizing correctly and leaving scroll bars where none were before. If anyone would like to see an example of this I have several, Phocas support tell me they have their dev team looking into it. ---
**Author:** ![telam](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/telam/32/120_2.png) [@telam](https://pug.phocassoftware.com/u/telam)\ **Post date:** [February 14, 2018, 5:45pm UTC](https://pug.phocassoftware.com/t/subtotal-and-stack-rank/499/6 "2018-02-14T17:45:12Z")
I would much rather they autofit rather than fill the screen. I don’t like seeing a bunch of empty space in a column, that’s unnecessary, IMO… ---
**Author:** ![StuartH](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/stuarth/32/394_2.png) [@StuartH](https://pug.phocassoftware.com/u/StuartH)\ **Post date:** [April 11, 2018, 2:00pm UTC](https://pug.phocassoftware.com/t/subtotal-and-stack-rank/499/7 "2018-04-11T14:00:49Z")
Could do with an option to retain subtotals of each dimension within the nesting feature. It’s great but once expanded you lose sight of the value of that section.