Using the standard syntax of a Hierarchy with Aggregate eg.
Code:
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?
ADO Data Shape - Filter aggregate
