Adding Pivot Tables Dynamically
 

I have written a routine that loops through each column in a pivot table and hides those columns that are not required - this works fine. I now need to write a routine that looks at the pivot table columns and adds the vales of certain columns together. This is achievable but where I am having problems is if one of the columns does not have any values in it hence will not appear on the pivot table. Adding a calculated field would not work because the column may not exist.