Creating List Reports | CLEARIFY

Excel Dynamic Lists with QQube

Dynamic Lists in Excel provide a convenient way to sort and filter rows of raw transactional data, or to provide a list of customers, items, accounts by company. It will also refresh on demand from the QQube database.

Clicking on a field from the QQube Excel Add-In will immediately add it as a column in Excel. (Click here for detailed instructions on this procedure.)

You can also cut and paste a column in a range list to move it and change the order.

However there are two particular limitations of note:

• You can't insert blank rows or columns
• You can't create subtotals (notice it is greyed out below)

In This Section

• Sorting Dynamic List Data
• Filtering Dynamic List Data
• Working with Columns
• Dynamic Calculations
• Helpful Formulas