Drill Down to Summarized Account Balances

Summary Drill Down functionality allows users to select which account segments to use for grouping or summarizing the accounts, when displaying the account balances making up the single GXL value. The drill down results appear in a single or tabbed panel, exclude zero balance accounts, and display or omit the Summary Drill Down panel, based on the option in the user's Spreadsheet Server Settings.

1. Select a cell containing a GXL formula, then, from the Spreadsheet Server Ribbon, select Summary Drill Down, or, right-click and select Spreadsheet Server > Summary Drill Down. The Summary Drill Down panel appears, listing account segments based on the GXL formula, and defaulting selections based on the last time the function was used.

Note: For JD Edwards ledgers only, multiple cells in the same row containing GXL formulas may be selected.

Tip: This panel may be bypassed the option in the user's Spreadsheet Server Settings, or, by clicking Summary Drill Down > No Prompt from the Spreadsheet Server Ribbon.


2. In the Summary Drill Down panel, select the account segments to be used for summarizing.
3. Click OK. The Summary Drill Down reappears, showing the balance for each detail account summarized, based on the account segments selected in the previous panel (for example, Company, Department, and Account in the below screenshot).


Note: The Journal List for Selected/All Accounts and Ad Hoc Drill Down options are not available from the Summary Drill Down panel.