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.
Top.png
I would like the fields in this order Skill2 below Skill1, not have Skill2 nested under Skill1 as in the above.
Top2.png
Bookmarks