I want to use a pivot table macro on datasets that will have different field names for the columns, rows and values. However, the same formatting and data extraction will be performed on all datasets. Is there a way to reference pivot fields without the names? For example, the field below is located in the Values section, position = 2. Is there a way to reference it without the name (e.g. just call it values, position 2) rather than using the actual field name "Count of 13..."?

Please Login or Register  to view this content.