Hello, I have a problem, I have a Query that pulls data to a dynamic table in Excel, however, there are 3 fields that do not exist in the database that need to be filled manually, but when updating the fields, they are sometimes disordered by are static, I wanted to know some way to nest these static fields with the ID of the PivotTable.
You will have to add your own -static- table to the file which contains the manually entered information. Make sure that table has a column with which you can link the information to the table which pulls data from the database. Now you can add the manual table to your pivot table and Excel will ask you for the relationship between the two tables.
Best Response confirmed by
Andr_Mattos (New Contributor)