I have two fields selected for row data. One field is product number and the
other field is location. There are 3 locations for every product. In the
pivot table I have the product number in the first column followed by the
location. I need to have the product number on each row next to the location
instead of the pivot table default of listing the product only once. Is
there a way to select this?