An analyst needs to filter the sum of the sales between 12 complete months ago to the last 9 complete months ago.

How can the analyst create this filter condition?

A. Custom filter “is in the past” 12 months AND “is before” “relative” 9 months ago

B. Sales Closing Date “matches advanced” “12 months ago for 3 months”

C. Sales Closing Date “is in the past” 12 months OR “is before” “relative” 9 months ago

D. Sales Closing Date “matches advanced” “between 12 months ago and 9 months ago”

Reference: https://community.looker.com/explores-36/index4.html