Custom Tables FAQs

Tips, Answers & Solutions for Frequently Asked Questions about Custom Tables

This article elucidates the frequently asked questions related to Custom Tables and offers insights on maximizing the efficacy of Custom Table utilization:

• Section's Subtotal
• Cannot "Save Changes" Custom Table issue
• Section Cloning
• Period Value Impact on Dashboards & Reports
• Moving Lines & Sections

Section's Subtotal

Adding Subtotal to the Section summarizes all the Lines, Reference rows, and Sections that are included under it.

To add the Subtotal of the Section, navigate to Settings ⚙️> Custom Tables > click on the ellipsis (. . .) to the left of the Section and choose + Add Subtotal:

 

Cannot "Save Changes" Custom Table issue

Several potential factors may prevent the successful saving of a Custom Table, causing the "SAVE CHANGES" button to appear greyed out. The most common reasons are:

• Not unique Sections and Lines' Names

Each Section and Line's Name within the same Custom Table must be unique:

To resolve the above issue, modify the Name of one of the Lines/Sections or add a distinguishing character to ensure they are unique.

• Section with the Subtotal added includes Lines with different format

To solve the above issue adjust the Number (#) Format to the Money ($) Format so all the lines' Formats added under the Opportunity Pipeline ($) Section incl. the Subtotal will be consistent. 

Section Cloning

A Section included the Custom Table can be cloned:

• within the same Custom Table by clicking on the ellipsis (. . .) to the left of the Section > Clone (Section cloned within the same Custom Table will be displayed below the Section that is cloning with the suffix "Cloned" at the beginning of the Name)
• to another Custom Table by clicking on the ellipsis (. . .) to the left of the Section > Copy to Table (Section cloned to another Custom Table will be allocated at the top of that Custom Table)

Period Value Impact on Dashboards & Reports

Each Line's Period Value determines the aggregation of data over time in Dashboards & Reports and can be set up as follows:

• Beginning Balance: take the first value in the period (e.g. Balance Sheet accounts such as Cash)
• Ending Balance: take the first value in the period (e.g. Ending Customers count)
• Sum: add up all the values in the period (e.g. Income Statement accounts such as Revenue)
• Average: take an average of all the values in the period (e.g. percentages such as Net Retention Rate)

As demonstrated in the below screenshots, the Period Value can be utilized to accurately identify the number of Reps at the End of the Month in the Reports area:

When Reps End of Month's Period Value is adjusted from Ending Balance to the Sum, the Total column will display the sum of Reps End of Month for July - December 2024:

 

Moving Lines & Sections

The order of Lines and Sections within the Custom Table can be fully customized. Once the structure of the Custom Table is established, adjustments can be easily made by clicking on the ellipsis (. . .) to the left of the Line or Section and selecting the Move button. You can then drag the Section or Line to the desired position.