A list containing customer and customer purchase information has the following columns: customer name,location (of the customer,i.e. ,North,South,East,and West),customer income,customer age,and mode of payment during last purchase (cash or card).A pivot table is created dividing the customers based on their location.Which of the following would result in the creation of a three-dimensional pivot table?
A)Adding the age field to "Column Labels"
B)Adding the age field to the "Values" field
C)Adding customer income field to "Report Filter"
D)Adding customer id to the "Values" field

Question

Quizplus · Accepted Answer

Adding the customer income label to the Report Filter area would result in the formation of a three-dimensional table with information filtered according to specifications.

A List Containing Customer and Customer Purchase Information Has the Following