Hello,
I have made an area plan that I'd like to be able to create a corresponding schedule (table) for, but I can't quite figure out how to "total" my patio areas. I'd like to be able to show LIVING area / GARAGE area / PATIO area. I generated a new Area Scheme based off the Rentable Area scheme and thought I'd be able to edit one of the 6 areas into "Garage", but it seems like they aren't editable. (ARE THEY?) That's fine, but when I generate an Area Schedule, it breaks down all three different types of areas and their corresponding areas, then it totals the entire thing. I would like it to total up just the outdoor "PATIO" areas and then basically provide me with the three totals:
LIVING = x,xxxSF
GARAGE = xxxSF
PATIO = x,xxxSF
I know you can group things in tables, but apparently not areas, or not elements in rows, only subjects on top like "Finishes".
I've attached the Area Plan I'm referencing as well as the table that relates to it...
Solved! Go to Solution.
Solved by ryan.duell. Go to Solution.
You should be able to achieve this by adjusting the schedule properties as follows:
1. Make sure Schedule Properties > Formatting > Area is set to Calculate Totals
2. Set Schedule Properties >Sorting/Grouping, Sort by Name, add a Title\Count\Totals, and check Grand Totals:
Hope this helps! Thank you,
Thanks Ryan,
I have tried working with those total's options before, but I could never figure out the right combination. There's so many options! This would make for a great video tutorial as I have to imagine just about everyone uses it. Course maybe it's something everyone but me has figured out!
Thanks again!
Is there a filter option that would allow me to not show categories that only have one area? If I were using your example, I wouldn't want to total the garage as it could be confusing. Or, could I change the text to say TOTAL instead of GARAGE: 1?
Thanks,
Logan