1Z0-1045 practice

Q1 Single choice

You are creating a standard report for a client to display LPN Numbers (for multi-SKU LPNs) and their associated items. The two data fields you have in your report are LPN Number and Item Code. Identify what controls need to be set to create a sub-total for the number of items for each LPN.

A
Set the Summary Function for item to "Count" and check the Summarize By box for LPN.
B
Set the Summary Function for item to "Total" and check the Group By box for LPN.
C
Set the Summary Function for LPN to "Count" and check the Summarize By box for Item.
D
Set the Summary Function for LPN to "Total" and check the Group By box for item.