View Single Post
  #1 (permalink)  
Old March 31st, 2008, 10:40 AM
dwperry dwperry is offline
Registered User
Join Date: Mar 2008
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default ADO Data Shape - Filter aggregate

Using the standard syntax of a Hierarchy with Aggregate eg.

SHAPE  (select * from orders}
   APPEND ({select od.orderid, od.UnitPrice * od.quantity as ExtendedPrice
            from [order details] As od}
          RELATE orderid TO orderid) As rsDetails,
          SUM(ExtendedPrice) AS OrderTotal
Can anyone tell me if there is a way to filter the parent set based on the value of the aggregate field?

ie. WHERE SUM(ExtendedPrice) > 100

Without using the COMPUTE syntax?

Reply With Quote