Please provide the pivot fields to be used. I am not well-versed with your data so its better if you let me know which fields to use so i can include it in the macro.