Hi everyone,

I'm trying to pull and calculate the total from a pivot table field to populate another table. The total sub total will not be checked so all I will have is the raw numbers that need to be added until the next Item in the pivot table. Kind of hard to explain but the attachment shows the information that I'm trying to get.

Pull from pivot table.xls