Pivot Table Field/Item question
Posted on 2012-03-13
Dealing with financial data. We have what are called budget versions. 1 and 11 for one month of actuals and then are 11 months of forecast. also a 2 and 10 that has 2 months of actuals and 10 months of forecast. The first thing I do is add budget version to the columns and then add all the months. So the title of my columns are Jan, Feb, Marc etc. and then repeats again for the next budget verions. Is there anyway I can select only Jan under 1&11 and November under 2&10? Currently when I select a month it addes it to both budget versions.