Constraining Queries
•Based on Comparision to Summary or Rank
–Avoid complex SQL query; let the application handle it.
–Show me sales by Product for Jan, only for Products that account for more than 30% of their brand totals
•Interrow comparisions – see Report 13.4
•Filter out rows < 30%
•