I have two measures in a pivot table. One is a simple sum and the other is the sum displayed as a percentage of the total. I'm using vba to pareto the results but the vba is struggling to distinguish between the two measures. Recording a macro comes back with the same measure name. Renaming the measures doesn't solve the problem. Any ideas ?