1 Reply Latest reply on Dec 9, 2011 5:40 AM by Shawn Wallwork

# Calculate from relationship to group/sum

I am having an issue where I want to create a calculation to group and sum my data based on the filter selected from the linked relationship.  For example:  If you select 3 from the time table and it is linked via "Date" to the sales table then I want it to sum all of the sales corresponding to dates for time 3. Therefore the overall link would be seen below with the tables they are in:

Time    Time          Time          Sales            Sales

3        2012011    CT          2012011          \$2000

3        2012012    CT          2012012          \$1500

3        2012013    PT          2011011          \$500

3        2012021    PT          2012012          \$2500

I want it so sum the first two lines together as 3 - CT and the second two lines together as 3-PT.

• ###### 1. Re: Calculate from relationship to group/sum

Katie, did you figure this out? If not can you provide a sample workbook? --Shawn