Thought that I might try again to encourage you to upload a sample .xlsx file. I feel that if we could see a small sample of your source data and get a sense of how you would set up your pivot table, then we may be better able to propose a solution.