A table card displays tabular data on a report page. For example, a profit and loss statement. Presentation tables display up to 300 rows and up to 50 columns.
To edit tables in a report, select Edit to open your page in designer mode.
Configure a table card
Note: When you add a presentation table to a report, the number of columns is fixed at the time of creation and doesn't change.
To configure a table card:
Select Configure on a new card, or hover over your card and select Edit .
Read how to add a card to a report.
Select a View to use as the data source for your card on the Overview tab of the Card configuration panel, and select Update.
Enter a Title and Description for the card. You can also link the card's title to a page from the Link to a page dropdown.
On the Format tab, you can apply Themes from the card template library, set Styles for presentation table elements, and Format line items.
On the Context tab, you can enable context selection, set the Context color, and enable or disable Sync on selection for line items.
Select the drag handle and drop your card where you want it to display.
Select Save to save as a draft, or select Publish.
Set the style of card elements
Note: Conditional formatting overrides any style you set in Card configuration.
To set the style of row and column headers:
Select Styles on the Format tab.
From the Style dropdown, select Headers anddata.
You can expand Row headers or Column headers and:
Select a Background color and Font color swatch, or enter a hex code.
Select an Emphasis style.
Set text Alignment.
Toggle Showheaders to the right to display headers.
You can expand Data, and select a Row style of Solid or Striped, and:
If you selected Striped, select a Stripecolor.
When Stripe color is different from Background, odd data rows display with the stripe color. Even data rows display with the background color.
Select a Background color and Font color swatch, or enter a hex code.
Select an Emphasis style.
Select Save to save as a draft, or select Publish.
To set the style of summaries:
Select Line item summaries or Time summaries from the Style dropdown, and:
Expand a style. For example, Normal text, Heading 1, Day, or Month.
Select a Background color and Font color swatch, or enter a hex code.
Select an Emphasis style.
Select Save to save as a draft, or select Publish.
Format an item
You can set the style of individual items to highlight or group them visually.
Note: Your most recent style and format changes override earlier changes.
To format an item:
Select Format on the Format tab.
From the Dimensions dropdown, select Line Items (Row) or a dimension.
Select an item from the next dropdown.
You can select a Background or Font color, select an Emphasis style, or set Cell alignment.
From the dropdowns, you can select the:
Number format.
Number scale.
Decimal places.
Decimal point.
Thousand separator.
Select Save to save as a draft, or select Publish.