/content/package[@name='GO Sales (query)']/model[@name='model'] [Sales (query)].[Time].[Year] [Sales (query)].[Sales].[Quantity] total ([Quantity] for [Current year]) median([Quantity] for [Current year]) [Sales (query)].[Order method].[Order method type] median([Quantity]) [Sales (query)].[Products].[Product] ='BugShield Lotion Lite' [Order method]='Web' [Current year] <2012 [Sales (query)].[Time].[Year] [Sales (query)].[Sales].[Quantity] [Sales (query)].[Order method].[Order method type] [Sales (query)].[Sales].[Quantity] median(total([Total for year] for [Current year]) for report) [Sales (query)].[Products].[Product] ='BugShield Lotion Lite' [Order method]='Web' [Current year] <2012 The query for the list below does not group and summarize the rows of data returned from the database. The median value is calculated based on the unaggregated database values, so the total and median values for the year are calculated useing the functions in the report expressions. Summary The query for the list below has the same data, but it is set to group and summarize the database rows the lowest detail level. The total and median for the year are calculated using the Aggregate Function property. The summary median for the year is calculated as a median of the database values, not the median of the aggregated anual totals. To get the median of the aggregated anual totals, you need to include the aggregation in the expression, as in the last column, or take the median of the aggregated Total for year query item. Summary