GPXQ Formula

The GPXQ formula displays a single value from the summary portion of a business view based on the selected field and aggregate function.

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

1. Use the following table to enter or modify data in the GPXQ 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.
Field	Select the field you want to summarize.
Function	Select the type of summary required for the field, for example, you can choose to add all the values, count the number of values, derive the average value, and so on.
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 summary portion of the business view displays in the cell.
3. To use the GPXQ formula in conjunction with the data generated through the GPXD formula, copy the GPXQ formula to the appropriate destination cell in the adjacent column of the GPXD results grid.
4. Select Execute Reports from the Spreadsheet Server ribbon. The Fill Down Column option configured in the GPXD panel copies and fills down the GPXQ formula to match the number of records in the grid.
5. To view detailed results, select the cell containing the GPXQ formula and then select Drill Down from the Spreadsheet Server ribbon or right-click and select Spreadsheet Server > Drill Down. The Drill Down panel displays the information.