How do I add a variable range of columns depending on criteria

N

Nedgingbelle

I have a pivottable of sales data for 2008 and 2009 with rows for customers
and columns of annual totals, subdivided into months. I can extract the 2008
monthly data for month 11 using getpivotdata, but what I also want to do is
sum months 1 to 11 to give me the 2008 year to date information. I could of
course, just filter month 11 out of the table, but then I won't have an
actual 12 month total for 2008. Any suggestions??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top