If you would like to show a subtotal of the wholesale price of a number of items of clothing on a PivotTable of data of both men and women. You have the following fields: Gender, Item and Price. Sum of Price is in the VALUES area. Gender is in the ROWS area. How do you get a subtotal of shirts and pants to display for each gender?

A) Drag the Gender field off the ROWS. B) Drag the Item field above Gender in ROWS.
C) Drag the Item field beneath Gender in ROWS. D) Drag the Item field to VALUES.


C

Computer Science & Information Technology

You might also like to view...

The map collection has a ‘get’ operation. Why doesn’t the set collection have a ‘get’ operation?

What will be an ideal response?

Computer Science & Information Technology

Explain why the Telnet session was established to one of the hosts with the duplicate address and not the other. Explain why the Telnet session was established at all and did not result in an error message. Use the ARP cache and the captured packets to support your explanation.

What will be an ideal response?

Computer Science & Information Technology

The ________ defines items on a web page such as graphics, tables, and headers as objects

A) DOM B) MIME C) SSL D) JSON

Computer Science & Information Technology

The white dots on the rectangle surrounding the Conference Call appointment in the accompanying figure indicate that the appointment is a meeting.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology