nerdexam
IBM

COG-612 · Question #9

An author wants to create a filter on this report to only show Product line totals larger than 1 billion. What calculation is used to create this filter?

The correct answer is C. Summary filter as: [Total(Revenue)]>1000000000Scope = Product line. See the full explanation below for the reasoning.

Question

An author wants to create a filter on this report to only show Product line totals larger than 1 billion. What calculation is used to create this filter?

Exhibit

COG-612 question #9 exhibit

Options

  • ADetail filter as: [Total (Revenue)] for [Product line] >1000000000Application = After auto aggregation
  • BDetail filter as: [Total (Revenue)]>1000000000Scope = Product line
  • CSummary filter as: [Total(Revenue)]>1000000000Scope = Product line
  • DSummary filter as: [Total(Revenue)] for [Product line]>1000000000)Application = After auto aggregation

How the community answered

(23 responses)
  • A
    9% (2)
  • B
    4% (1)
  • C
    83% (19)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full COG-612 Practice