Hi Vijay, Please ignore parts of my previous email. The solution is a bit more complicated.
Of the three metrics only the Adspend is truly additive. Summing the category fields makes no sense. This means you have to design the implementation of the SummarySetOperations class so that it makes intelligent choices for the category fields. For example, If the same UserID appears in your data with two different genders, you will have to choose, perhaps the last one?? For the AgeGroup, perhaps the older of the two groups?? These conflicts are issues you would have to deal with no matter how you constructed your solution! Processing the final sketch will require a bit more care as well. When doing your iteration through the sketch retained items, you may need to do additional filtering if the user has queried multiple coordinates from the same dimension. I'm sure you can figure this out. Lee.
