I have a Pivot table that is always changing when I update it. I want to create a manual table that says (ex. go find Arizona's sales # for October and then add xxxxxxx)
In the pivot table, Arizona would be on y-axis and the current month on x-axis. values are sales figure.
The pivot table is constantly moving forward though. Like I can only see the current month's number for each state.
I dont "GETPIVOTDATA" would work because it will always be locked to certain month. Should I use vLookup?
I wouldn't reference a formula to a pivot table. I would reference the formula to the data table feeding the pivot table. If you reference a vlookup to the pivot table and for any case you filter the data excluding your lookup criteria, you'll get errors...
If you need help on extracting data from the data table, give us more details as to what you want and we can give a few formulas to try,
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
Regards formulae - given use of XL2007 see:
SUMIFS, COUNTIFS, AVERAGEIF, AVERAGEIFS etc... in XL Help
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks