Area schedule formatting

[Anonymous]

Hello,

This seems like it should be a basic function, but I cannot find anything that tells me how to do it.

In short, I want to have an area schedule that has my Gross Building Area and my Exterior Area for the same unit side by side, not underneath each other.  I've posted 2 screenshots - 1 of what I have in revit, and 1 of what I would ideally like, created in excel.  

Help?

[barthbradley]

Select header cells and click Merge Unmerge

...or do you want to Group?  

5 Tips and Tricks for Schedules in Revit Tutorial - Bing video

Group Column Headings in a Schedule | Revit LT 2020 | Autodesk Knowledge Network

[Anonymous]

Hi @barthbradley 

I did have a look at this video (and many others) before posting, but it doesn't cover my issue.  The issue is, I want Gross Building Area and External Area (and ideally, the total of the two) side by side in a schedule, not underneath each other.  Almost as if the individual columns were filtered to show each type, I suppose.  I'm sure there has to be a way of doing it, but I can't figure it out.

[barthbradley]

no, there isn't any way to do that.  

...post your file.  

[ToanDN]

Sure you can.  See attached Revit 2022 file.

[Anonymous]

@ToanDN unfortunately I'm still in Revit 2020 and can't open the file, but I am VERY KEEN to know how you did that!!

[ToanDN · Accepted solution]

- Add a Yes/No parameter (Exterior) to the schedule

- Check boxes for Exterior rooms and clear boxes for Interior rooms

- Add Calculated Value parameter: Exterior Area = if(Exterior, Area, 0 m²)

- Add Calculated Value parameter: Interior Area = if( Exterior, 0 m², Area)

- Format Area, Exterior Area, Interior Area to Calculate Totals

[Anonymous]

Thank you, this fixes it exactly!!  Great solution.