At then end of each 'Group2', I need to display the sum of all the items in that Group2. At then end of each 'Group1', I need to display the sum of all the sums calculated at the end of each 'Group2'
Currently, I have just placed a summary field at the end of both Group1 and Group2. However, I'm not sure that this is the best way to do this, because then the Group1 sum is calculated by adding up all the data items again, even though it could just add up the Group2 sums, and I have a LOT of data items.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum