Hi,
I have a table that lists incoming containers by week number. The total incoming containers are classified as either going to DC1 or DC2. The total going to DC1 or DC2 is calculated by summing the cubic ft for that week and dividing by container cubic feet. I want to make a pivot chart which will plot total containers going to DC1 versus total of DC1 and DC2.
Can this be done? Is there a work around?

Thanks.