I have a spreadsheet and I am trying to pull the quantity purchased in the current month, plus any open back-orders we may have for that item. Is there a way to have the GETPIVOTDATA function to pull data from any date before a specified date?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
GETPIVOTDATA Help
- Thread starter barrowb
- Start date
-
- Tags
- getpivotdata pivot tables
Jerry Sullivan
MrExcel MVP
- Joined
- Mar 18, 2010
- Messages
- 8,787
Hi barrowb,
As far as I know, the GETPIVOTDATA worksheet function will only return a value from a single cell in your PivotTable.
You could consider...
1. Using a calculated field or calculated item to display the current month plus back-orders value
2. Summing multiple GETPIVOTDATA() expressions (if the list of dates is short).
3. Using lookup functions like Index-Match to find and sum those values.
4. Using a query of your source data that filters just those records that meet your criteria.
As far as I know, the GETPIVOTDATA worksheet function will only return a value from a single cell in your PivotTable.
You could consider...
1. Using a calculated field or calculated item to display the current month plus back-orders value
2. Summing multiple GETPIVOTDATA() expressions (if the list of dates is short).
3. Using lookup functions like Index-Match to find and sum those values.
4. Using a query of your source data that filters just those records that meet your criteria.
Upvote
0
