Pivottabel / running totals / year-to-date

[Peter Lyng]

Hi

I have sales figures that I would like to show in a chart where I have the current month and year-to-date totals. Using a dropdown/validation list with 12 months my boss is able to see the numbers by just changing the month.

In different sheets I have to separate pivot tables.

My problem is this: In one of my pivot tables there are no sales in March so when my boss wants to see the year-to-date total for March - accumulated sales from January and February is not included. If he choose April then the total is correct because there are sales in April.

Hope some can help me out and understand the question.

Kind regards

Peter


EggHeadCafe - Software Developer Portal of Choice
XCeed Streaming Compression Library
http://www.eggheadcafe.com/tutorial...f-769ec7085cf2/xceed-streaming-compressi.aspx

 

[Dave Peterson]

If you're only showing sums (not counts), maybe you can add a bunch of dummy
data records to the raw data (one for each month) that have 0 sales.

When I had to refresh the raw data, I would make my life a bit easier by keeping
a worksheet with all the dates I needed with 0 sales and just copied to the end
of the real data.