jacobidiego wrote: a) Can you help me to get the above behavior?
I don't think you can do what you want with AC schedules.
b) Is it possible to use Excel and Pivot tables, to summarize this data? ¿Can it be connected to an AC internal database?
This is the better option. AC will let you list everything you need, but when it comes to filtering, arranging, grouping, etc... the data, a spreadsheet editor will get you there sooner. The way to get this to work is to set up a publisher set for your schedules. Save either as .xls or .txt and link the information (don't just open and edit the resulting files). Should you make any changes, you just click publish again and wait for excel (in this case) to update everything.
I explained this in detail in another thread. Use search to find it.
Thank you!! I will try with that approach as soon as I get more used to AC.
Another way would be to access the database through SQL but this requires registering as a developer, which seems more bureaucracy.
Rightnow, i am exporting it to a an Excel, and create there the quotation calculation.
One further problem that I have, is that, this building will be built in stages depending on the hause zone and meaning, I am trying to use zones for it but elements dont get assigned to it.
Because of this, I can not filter them in Excel..