Hi, I have my pivot chart created correctly, but am having issues with what i want it to do.




I am trying to make a pivot chart to track emails. I would like the chart to display the totals for how many emails come in each day by source. My issue is that my pivot chart will add a new day of the week onto the chart rather than adding that amount to Monday.

Ex. I have Monday - Sunday on the chart with 10 emails coming into each, when i get to the next Monday instead of adding 10 more to the total for Monday (making it 20), the chart adds another instance of Monday onto the chart with a total of 10.