I have a sales table that totals, with a summary field, the quantity of items sold to date, sorted by the item's SKU. That is:

Table 1 - Total Shipped_Title Sort (Summary) - Total of Quantity (running with restart), when sorted by SKU.

On another table that also uses the SKU, I've used a calculation with the GetSummary function to show the quantity sold to date for each item. That is:

Table 2 - Total Sales (Calculation ) - GetSummary ( Table 1::Total Shipped_Title Sort ; Table 1::Total Shipped_Title Sort )

But, I'd also like to break down the sales by year. On the original table, I created a summary field that appears in a sub-summary part that separates the quantities by year, so:

Table 1 - Total Shipped_Year Sort (Summary) - Total of Quantity (running with restart), when sorted by Year.

However, I can't seem to use GetSummary to bring that figure over to the second table. I tried:

Table 2: Total Sales 2010 (Calculation) - GetSummary ( Table 1::Total Shipped_Title Sort ; If ( Table 1::Year >= "2010" ; Table 1::Total Shipped_Title Sort )

but that doesn't yield any results. On Table 1, the data is sorted multiple times (by SKU, and then by Year) to get the sales-by-year summary; I don't see how I can double-sort a GetSummary function.

Is there a way to use multiple break fields, or otherwise to summarize with GetSummary only the quantities on records that match a certain filter (like the year)?

Thanks much.

Is there a way to use multiple break fields, or otherwise to summarize with GetSummary only the quantities on records that match a certain filter (like the year)?

I have the same question!