Hi,
Im wrangling a pivottable based off a single table. Its displayed in a tabular format. The table has property sale document number, price, sale date, buyer, seller, land description (e.g. Lot on Plan), certificate of title and I have got calculated fields for total area and, number of lots
I wish to display a single row for each sale and adding the total area and counting the number of lots included with the sale. Some sales are single lot which are fine, but some are 2 or more. Is there a way to group the lots into a single line against the unique sale document number, identifying just one of the lots then add the area, and count lots?
Hopefully this makes sense!
Thanks
Im wrangling a pivottable based off a single table. Its displayed in a tabular format. The table has property sale document number, price, sale date, buyer, seller, land description (e.g. Lot on Plan), certificate of title and I have got calculated fields for total area and, number of lots
I wish to display a single row for each sale and adding the total area and counting the number of lots included with the sale. Some sales are single lot which are fine, but some are 2 or more. Is there a way to group the lots into a single line against the unique sale document number, identifying just one of the lots then add the area, and count lots?
Hopefully this makes sense!
Thanks