Drill Down to Multi-Column Account Balances

Spreadsheet Server allows drilling down from multiple cells in the same row of a spreadsheet to see which account balances make up the values. A maximum of 80 columns may be selected. The drill down results appear in a single or tabbed panel or worksheet, and exclude zero balance accounts based on the options in the user's Spreadsheet Server Settings.

Select multiple cells in the same row containing GXL formulas, then, from the Spreadsheet Server Ribbon, select Drill Down, or, right-click and select Spreadsheet Server > Drill Down. The Multiple Account Balances drill down panel appears, showing detail account balances for each column. If only two columns are selected, a variance column will automatically be displayed.

Tip: Drill down results may also be pushed directly to a panel or worksheet by clicking Summary Drill Down > Multiple Accounts Balances from the Spreadsheet Server Ribbon.