Summing Data just like in List view
I would like to know how I could sum data like I do in list view IN A COLUMN CHART! I am trying to show "total weekly sales" for each "office". I already have the correct week #'s and I can make this view peferctly in "list" view. However, when I try to make it in a chart each office's daily entry shows up as a separate bar. So for instance "Seattle" would show up three times vs being summed and showed once against all the other offices. Please advise. Thank you!