Using Drilldown

Created by Damien Zwillinger, Modified on Thu, 05 Oct 2023 at 05:50 PM by Gabriel Michaud

Applies to:

  • Velixo NX
  • Velixo Classic
  • Acumatica, Cegid XRP Flex, MYOB Advanced



A Velixo Drilldown feature presents a summary of underlying data that corresponds to a cell containing a Velixo function.


A simple example will demonstrate how easy it is to create a drilldown.


Let's consider a chart of accounts which lists the ending balance for each account. In this list, we locate the Sales Revenue account and click on the Ending Balance cell (see the figure below).


In this example, the values being displayed are computed using the ACCOUNTENDINGBALANCE function.


To get a drill-down for this number, we would click the Drilldown button on the Velixo ribbon.


This opens a new worksheet tab which displays summary information for sales revenue corresponding to the specifications of the account ending balance function.



  • Another way to perform a drill-down is to right-click over a cell and click Drilldown.

  • You can perform as many drill-downs as you like. Each additional click of the Drilldown button will open a new worksheet.



The Drilldown worksheet

In a Drilldown worksheet, we can quickly navigate to the reference data:


  • We can click any of the links in the Source Cell column to return to the original Velixo function.

  • We can click any of the links in the Transactions column to open the corresponding generic inquiry results within your ERP:



These tips will help us get more out of the drill-down feature:


  • Before drilling down, it is recommended that we Refresh our results. Even when a cell may display an outdated value from a prior refresh, the drill-down will always contain the latest information from your ERP.

  • Drilling down can also be performed on certain Excel summarizing functions (e.g., SUM & AVERAGE).

  • To improve performance, we'll want to minimize the number of cells that we include in our drill-down.


  • If we are using SUMIF, VLOOKUP, HLOOKUP, MATCH, or the INDEX function, the drill-down won't work. This is because it cannot identify all of the cells that were included. Since Excel applies formula auditing, it includes the entire source range in such functions, and the drill-down feature cannot display the complicated results.

  • Complex math operations cannot be represented, since a drill-down merely presents a summary of all the relevant accounts.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article