PIvotitems visible
 

I have Dept, Gender, and Qty fields in a PT. I can make visible the Dept
pivotitems that i chose, but am unable to then loop through the correct
remaining Gender pivotitems within that dept. Unable to get the correct
'count' nor identify the Gender items that are specific to that dept. My
goal is to create one master PT for the entire dept, and then create
individual PTs underneath for each individual Dept/Gender.