GPXS Formula

The GPXS formula displays values returned from a business view in the Parameter Selector panel when you drill down on the selector text in the worksheet.

See Business View Formulas to learn how to access the GPXS panel.

1. Use the following table to enter or modify data in the GPXS panel.

Field	Description
Name	Select the required business view. Business views are available based on user permissions. Use the drop-down menu to select the business view. Click Browse to open the Select Business View panel which retrieves a list of all the business views from Angles within Excel. Search by text. Search by tags. Select the checkbox against the tag(s) in the drop-down menu and click Apply to filter the list. Click Expand All to view all business view descriptions or click the expand icon against individual business views. Select the radio button to use that business view. Click the refresh button to load any newly added or assigned business views.
Sheet	Select the worksheet destination for the formula. Defaults to the current active worksheet.
Starting Cell	Enter the starting cell for the template.
Clear/Shift Worksheet	Choose to clear the entire worksheet, overwrite the existing data, shift the existing data, or overwrite with parameters when inserting the value.
Selector Text	Enter the label to display in the worksheet.
Cell for Value	Enter the cell for the output.
Parameters	Displays the list of columns based on the selected business view. Select the Select All checkbox to include all the columns or deselect the checkbox to exclude the columns from the formula. To select specific columns, select the checkbox against the columns. Note: If you select more than 125 parameters, an error message displays the number of parameters exceeding the limit that you must deselect. Choose to view the details in a row or column. You can use the following filters in the Value field against a column to display specific records: Enter [value] to retrieve a single value. Use * to retrieve all the values. Use [value]* to retrieve values starting with that value. Use *[value]* to retrieve values containing the value. Use [value].[value] to retrieve values within a range. A one-year time range filter displays in the first row by default. Use [value],[value] to retrieve the list of values. Use /[value] to exclude a value. Use ^[segment] to retrieve values in a segment list. Use <[value] to retrieve values greater than that value. Use >[value] to retrieve values less than that value. Use <=[value] and >=[value] to retrieve values that are equal to and greater than or equal to and less than that value respectively. Click the ellipses button (...) to view and select distinct parameter values from the list displayed in the look up window. Use the refresh button to repopulate the list of available values.



2. You can perform one of the following actions:
   1. Click Preview to view the first twenty records of the parameters included in the business view in the Drill Down window based on the applied filters. You must select a business view in the Name field to use this function.

   

   2. Click Insert or Update to run the formula. The selector text displays in the cell.
3. Select the cell and then select Drill Down from the Spreadsheet Server ribbon or right-click and select Spreadsheet Server > Drill Down. The Parameter Selector panel displays all the columns of the business view.
4. Select the output column to insert that specific value in the worksheet. You can use the search bar to locate a value or click a column header to sort the values.
5. In the grid, select the value(s) you want to insert. You can use the ctrl key to select multiple values and the shift key to select a range of values.
6. Click Insert.



7. The values display in the worksheet with the selector text working as the header.