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

    Expand Collapse

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

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page