I've exported data from Revit via Dynamo to excel (you won't need any knowledge about those two for this topic) that creates a data dump with 3 (relevant) colums:
-Panel Type
-Floor
-Amount (number of panels)
From this dump I've made a pivot table with the Panel Type in Rows, the Floor in columns and the Amount in Values.
What I want to add to it is another column which can show the ordered panels and can be manually adjusted as well as a column showing the difference between the exported number of panels and the mannually added column with ordered panels.
Now you might wonder "why not just add a column with a basic formula", the issue is that the Pivot table will change, partially because I want to build a template to be used for different projects, on the other simply because a project might be revised and different panel types might be added. Next to that, for the simple reason that I'd like this column to show more to the left in the table.
I hope someone has any tips on setting this up (if possible). Thanks in advance!
Bookmarks