問題文
A client wants to label every customer whose first order happened more than one year before the order being viewed, in a view that lists individual orders. Which expression shape is appropriate?
選択肢
- Compare the order date with a dimension filter that keeps the customers whose first order is old enough.
- Compare the order date with a table calculation that returns the running minimum along the rows of the view.
- Compare the order date with a parameter that holds the cutoff date chosen by the person reading the view.
- Compare the order date with a level of detail expression that fixes the earliest order date for each customer.