How do I design a pivot table that will allow me to add additional data past the last pivot table fields? In the example below would set up pivot table in rows for Name, Address, City, State, Site ID. But would like to have he additional data to also be added... DataX, DataY, DataZ.
Thank you...