Al Delgado
Member
I have 3 fields (Skill1, Skill2 and LastName) in a pivot table, if I add the three fields as rows I get the following nested report. To add to the confusion Skill1 and Skill2 both have the same possible text contents; Excellent or Very Good or Good or Fair or Poor.
Nested View
Skill1 Skill2 LastName
Excellent
Fair
Good Fair
Poor Mcmahon
Good Larsen
Poor Goodman
Very Good Campbell
Excellent
Very Good Ramos
Good Jensen
Richardson
Poor Richardson
Crawford
Huber
Huber
I would like the fields in this order Skill2 directly below Skill1, not have Skill2 nested under Skill1 as in the above.
Desired non-nested view, is this possible?
Skill1 LastName
Excellent
McMahon
Fair Smith
Good Campbell
Goodman
Larsen
Poor Goodman
Larsen
Crawford
Huber
Jensen
Ramos
Richardson
Very Good Huber
Jensen
Ramos
Richardson
Jones
----Skill2 LastName
Excellent
Ramos
Smith
Smith
Fair
Bright
Henson
Johnson
Good Henson
Johnson
Foster
Jensen
Larsen
Poor Jensen
Larsen
Crawford
Gallegos
Goodman
Very Good Gallegos
Goodman
Campbell
Foreman
Foreman