Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Help: Wildcard Charaters

Discussion in 'Information Technology' started by bbddvv, Jul 28, 2006.

  1. bbddvv

    bbddvv
    Expand Collapse
    Guest

    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
     
  2. Loading...


Share This Page