Suppose the following scenario:
My project has two identical windows, both marked with the ID 'WD-001'. One of them is in the kitchen, the other one is in the bathroom. 'Kitchen' and 'Bathroom' are zone names, so I selected 'from Zone Name' as one of the fields.
I want a Interactive Schedule that shows the quantity per ID of each window and the room in which they are (among other fields).
The picture attached shows above what I was able to get, and below what I would like to get.
Is there any way to join the zones in the same column so that all windows with same ID (but in different zones) appear only once and the quantity shows the sum of windows of that type?
--- www.dtabach.com.br ---
AC 24 BR – MacBook Pro 2,9 GHz Intel Core i7 16GB RAM Mac OS 10.14