asked on
Pivot Table Field/Item question
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.
Thanks
Thanks
Microsoft Excel
Last Comment
BigWill5112
are you able to post an example
ASKER
See Attached. I want only February for 2011 to show and March of 2012.
PivotTable-only-certain-months-a.xls
PivotTable-only-certain-months-a.xls
I think you will need to add an additional column on your table called for example "Display" and have this value Yes or No, you can then use that in your pivot table to display months, or not, see example.
You can use some kind of logic to determine if a value displays or not, see example.
ee-budget-versions.xls
You can use some kind of logic to determine if a value displays or not, see example.
ee-budget-versions.xls
ASKER
I don't like that it is not possible with the pivot table function but bravo on your suggestion. Gonna leave the question open for a little while to see if somone else can top that but otherwise they are your points. thanks.
No problem, I am happy to think about this some more too
ASKER
I lied. I assumed the data looked a certain way on my export. Bummer. The attached is what it actually looks like. I've tried working magic on it like you did but can't seem to get it to work. Can you give this one a shot?
Thanks.
PivotTable-only-certain-months-a.xls
Thanks.
PivotTable-only-certain-months-a.xls
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Can't figure it out either. And yes I agree that I need to change the way I am tabulating but I don't think I can in my system. I got around the issue by doing without the pivot table as suggested.