ExcelBanter - HELP: Wildcard Characters

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - HELP: Wildcard Characters (https://www.excelbanter.com/excel-discussion-misc-queries/96548-help-wildcard-characters.html)

bbddvv

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

All times are GMT +1. The time now is 07:08 AM.