GETPIVOTDATA all or none items in a field
I have a problem at hand where am hoping to populate a table based on data summarized in a pivot table using GETPIVOTDATA. The table is only used to display the pivot data in a more appealing fashion. The table is as follows
Each "Type" is a "Field" in the pivot table with multiple items. Say one "Field" has the "items" Aa and Ab and another has A1 and B1. Each "Type" are cells with data validation allowing for these multiple items to the selected. The GETPIVOTDATA populates the data accordingly.
Is it possible to formulate the GETPIVOTDATA function in such a way that when I select something like "All" I get the total of both items Aa and Ab? Something like an "all or none" criteria in GETPIVOTDATA. Or even some way to exclude the "Field" in case of 'all'.
Thanks in advance.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By mike703 in forum Excel Formulas & Functions
Last Post: 10-05-2012, 02:24 PM
By economix in forum Excel Charting & Pivots
Last Post: 09-24-2012, 10:57 AM
By andrew in forum Excel Formulas & Functions
Last Post: 05-30-2012, 08:48 PM
By RoboStat in forum Excel General
Last Post: 05-09-2006, 10:20 PM
By Rayo K in forum Excel Formulas & Functions
Last Post: 02-16-2006, 05:25 PM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1