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