Is it possible to create a new field in a QV document in a VBscript macro ? This new field would be used as a dimension in a Pivot Table. New field value is an expression which contains a call to a function in my VBScript.
Here an example : I create a pivot table with a dimension "country". I write in VBScript a function getCountries() which returns an association between countries, areas and subareas. I would like to add two dimensions in my pivot table, for area and subarea. How to do it with VBSCript code ?