IBM
P2020-300 · Question #51
Click the Exhibit button. Referring to the exhibit, yourmodel has two calculations ?"Revenue"and"Commission"- partitioned byPayeeID, ProductGroup, Product, and Month. What must you create to produce…
The correct answer is C. additional calculations to sum the results partitioned by ProductGroup and Month. See the full explanation below for the reasoning.
Question
Click the Exhibit button. Referring to the exhibit, yourmodel has two calculations ?"Revenue"and"Commission"- partitioned byPayeeID, ProductGroup, Product, and Month. What must you create to produce the summary report that shows revenue and commission by ProductGroup and Month?
Exhibit
Options
- Aa Data Store that joins both calculations and select ProductGroup and Month as detail columns
- BAggregate Transformations in Presenter partitioned by ProductGroup and Month
- Cadditional calculations to sum the results partitioned by ProductGroup and Month
- DCalculated Rows in Presenter that sum both values by ProductGroup and Month
How the community answered
(32 responses)- A19% (6)
- B6% (2)
- C72% (23)
- D3% (1)
Community Discussion
No community discussion yet for this question.