HELP: Wildcard Characters
In the following GETPIVOTDATA function, what wildcard characters can i
replace the "?????" in the below equation to cover all "Regions"?
=GETPIVOTDATA("Sales",A4,"Region", ????? ,"Company","Brooks Inc")
My PivotTable looks like this
Column 1: Region
Column 2: Company
Columns 3-10: various data
Thanks in advance,
Brad
|