I have to develop some pivot tables with the same columns, the difference is the dimension, in one is the product, other the category, other the trademark of the product.
Can i put in the document a dropdown field, for example, with the options for the dimension and in the pivot table, in the dimensions property, reference the value of the dropdown fields instead directly the name of the field to avoid create five or six pivot tables?
I would suggest using a group for the dimensions. Under Settings > Document Properties > Groups you can define a dimension group and add the fields you want to this group. Then add the group as dimension in your chart and you'll be able to cycle through the dimensions without having to change the expressions.
