Cross table

Chart data

A cross table consists of rows and columns, which you populate with dimension and measure fields.

• Add dimension fields to Rows and measure fields to Columns:

  1. On the Data tab, select the required dimension and measure fields:

     • In the Dimensions list, find area, product type, and product box. Double-click or drag these fields to the Rows area.

     • In the Measures list, find order amount, shipping cost, and profit amount. Double-click or drag these fields to the Columns area.

  2. Click Update. The chart updates automatically.

     

• Add dimension fields to Rows and both measure and dimension fields to Columns:

  1. On the Data tab, select the required dimension and measure fields:

     • In the Dimensions list, find product type and product box. Double-click or drag these fields to the Rows area.

     • In the Dimensions list, drag province to the Columns area.

     • In the Measures list, find order amount, shipping cost, and profit amount. Double-click or drag these fields to the Columns area.

  2. Click Update. The chart updates automatically.

     

• Add measure fields to Rows and dimension fields to Columns:

  1. On the Data tab, select the required dimension and measure fields:

     • In the Dimensions list, find area, province, and product type. Drag these fields to the Columns area.

     • In the Measures list, find order amount, shipping cost, and profit amount. Drag these fields to the Rows area.

  2. Click Update. The chart updates automatically.

     

  Note

  • A cross table supports an unlimited number of dimensions and measures in its rows and columns.

  • You can export up to 10,000 rows from a cross table. Export time depends on your computer's configuration and data volume. For more information, see Export data.

  • If a field is configured to display images, you can set the image's display size. On mobile clients, image width and height default to half the size set for the PC client.

• You can set filter conditions in the Filter section. See Field filtering for details.

  

Data tab configuration

On the data tab, you can:

• Add multiple fields at once

  To add multiple fields, press and hold Shift (or Command on macOS), select the target fields, then drag them to the destination area.

  

• Hide fields

  You can hide dimensions and measures in the rows section and columns section. You can hide fields in one of the following ways: (1) hide a measure field from the editing interface, (2) enable content filtering for a field on the Style panel, (3) add a query control, or (4) add a filter.

  Keep in mind the following behaviors:

  • If you hide a dimension in the rows section, it is not displayed in the chart, but its values are still used for grouping and calculations.

  • If you hide a dimension in the columns section, it is not displayed in the chart, but its values are still used to calculate grand totals.

• Set alignment

  • For horizontal alignment, you can select Left, Center, Right, or Auto.

    

  • For vertical alignment, you can select Top, Middle, Bottom, or Auto.

    

  • You can also align multiple fields at once. Click the icon on the field panel. In the field settings dialog box, select the fields that you want to align and choose an alignment method.

• Sort

  • Sorting options include: None, ascending, descending, ascending in group, descending in group, and Custom. You can also use the sort by field or advanced sorting options. For more information, see sorting.

  • Sort by field: You can sort a dimension in the rows section by a measure or by another dimension.

    

    • You can sort based on a measure that is already added to the data tab.

      ① Select the added measure field.

      ② Select a sort order. The icons, from left to right, represent ascending, descending, ascending in group, and descending in group.

      

    • You can sort by a measure or dimension field in the dataset.

      For example, the following figure shows how to sort by profit_amt.

      

    Note

    The sort by field option is available only for dimension fields.

  • Advanced sorting: This feature is typically used for aggregate tables and detail tables.

    You can apply advanced sorting to dimensions in the rows section and columns section.

    

• Aggregation: Supported aggregation methods include Sum, Average, Count, Count Distinct, Max, Min, Population Standard Deviation, Sample Standard Deviation, Population Variance, Sample Variance, Start Time Point, and End Time Point.

  

  • Start Time Point: You can set the aggregation method for a column field to Start Time Point and select a corresponding date field. After configuration, the field in the cross table displays the data that corresponds to the start time point.

    

• Advanced calculation: Supported advanced calculations include date accumulation, cumulative calculation, percentage, ranking, TopN, percentile, and year-over-year and month-over-month comparisons.

  

  • Date accumulation calculates the cumulative sum of data from an initial date to the current date. For more information, see date accumulation.

  • Cumulative calculation provides a running total of values returned from a data query. For more information, see cumulative calculation.

  • Percentage: You can display data as percentages to see the proportion of each value.

    In this example, you can view the percentage of order amounts for each province, as shown in the following figure.

    

  • Ranking: Ranking allows you to order grouped measures by their numerical values, making it easier to compare data.

    For more information, see ranking.

    

  • TopN: This feature retains data ranked in the top N positions. For example, selecting Top 5 keeps the top five records. You can also customize the ranking method and the value of N. For more information, see TopN.

    

  • Percentile: This calculation ranks query results by percentile, helping you see where a data point falls within the entire dataset. For more information, see percentile.

    

  • Year-over-year and month-over-month: You can configure year-over-year and month-over-month comparisons for a measure. For more information, see year-over-year and month-over-month.

  Note

  When you create a new calculated field in a dataset, you cannot directly reference a field that is based on an advanced calculation, such as a percentage. As a workaround, first obtain the result by using a custom SQL query. Then, create a new field in the dataset to reference that result.

Configure chart styles

This section explains how to configure styles for a cross table. For general chart style settings, see Configure the chart title.

To quickly find a setting, enter a keyword in the search box at the top of the configuration panel. Alternatively, click the icon to expand or collapse all categories.

• In the Basic Table Styles section, configure the appearance of the cross table.

  

  Parameter	Description
  Custom table theme	Sets the appearance of the cross table. Theme Style: Select Default, Wireframe, Simple, or Minimum. Major Color: For the Default, Wireframe, or Simple themes, select a major color for the cross table. You can follow the Theme Color, use Gray, or specify a Custom color. Show Zebra Stripes: Shows alternating row colors (zebra stripes) and lets you specify their color.
  Text	Sets the text style for the cross table.
  Column width, row height	Sets the column width and row height for the cross table. Options are auto-fit or Custom. Auto-fit: The system automatically adjusts column width based on container space and row height based on cell content. This mode uses space efficiently and ensures all text is visible, making it ideal for responsive layouts. Custom: Manually enter column width and row height values for a precise layout. This mode is ideal for scenarios that require high-precision formatting. After you select custom mode, row height and column width are set to Auto by default. You can clear the Auto checkbox to specify a pixel value. If you are unsure of the exact row height, drag a row divider to visually adjust it and find the optimal setting. When you drag a divider, the height of all rows in that area updates, and the new pixel value appears in the corresponding setting field. Note Column width and row height settings are independent for PC and mobile and can be configured separately.
  Adaptive table height, maximum height	Sets the table height to either fixed or adaptive. Fixed Height: The table height is fixed by default. Adjust the height manually by dragging the container's border. Adaptive Height: Allows the table container to automatically adjust its height based on the data content. You can also set a maximum height for the table, which limits the total height of the header and data rows. The table's height will not exceed this value. Available maximum height options are: 192 px (approx. 5 rows), 352 px (approx. 10 rows), 672 px (approx. 20 rows), 1632 px (approx. 50 rows), and Custom. Note If the row height is set to Custom, the Adaptive Table Height option only supports a custom value. You must specify a custom maximum height for the table. You can click the icon at the top of the page to switch between PC and mobile views and configure adaptive height settings for each platform separately. On mobile, adaptive height is enabled by default. You can only adjust the maximum table height. This feature can affect the report's layout. Enable it only when necessary.

• In the Display Settings section, configure cell display options, sorting, and other settings.

  

  Parameter	Description
  Display mode	Select tiled display or tree view. If you select tiled display, the cross table appears in a flat, two-dimensional format.
  	If you select tree view, dimension fields are displayed in a hierarchical structure. Customize the row label name and the default display level. Export by Expanded Level When selected, exporting with formatting reflects the tree view's current expanded or collapsed state in the exported Excel file. For example, if the display level is set to 3, only data within the first three levels is exported. Note If pagination is enabled, only the current page is exported. To fix this, disable pagination or increase the rows per page before exporting. If no subtotal is configured, parent levels in the exported cross table will not display data.
  Freeze	Freezes the Table Head or specific Columns. Note If you freeze Columns, ensure that the total width of the frozen columns is less than 60% of the total table width.
  Display measure group	Lets you set up a measure group display. If you enable dimension/measure mix, you can also group dimension fields and add a group description.
  Merge same cells	Merges cells with the same value.
  Wrap text	To maintain a clean layout, you may need to apply text wrapping differently to various table areas. For example, if the header text is short but the content text is long, you can wrap the text in the content area to keep the table compact. Select the Wrap Text checkbox to automatically wrap long text in the content area. Note The cross table recognizes newline characters, which you can use to customize text wrapping. This option only controls text wrapping for the content area. To configure text wrapping for the header area, see Header settings.
  Image field display mode	If the chart contains an image field, you can set its display mode. Options include Scale to fit (maintain aspect ratio), Crop to fit (maintain aspect ratio), and Stretch to fit. Note You can use the Image Field only when the dataset contains an image field of the image type (). For more information, see Use image dimensions in dashboards.
  Show measure name in single-measure column	If the columns area of a cross table contains a dimension field and only one measure field, you can select Show measure name in single-measure column. This displays the measure name in the column header, making the table easier to understand. Without this option, the numbers in the content area are ambiguous, as viewers cannot determine the metric (such as sales or profit) without context. After you enable this option, the measure name appears in the column header, allowing viewers to immediately identify the business metric being analyzed.
  Sort mode	PC: Set the sort mode for the cross table. All Modes: Displays all sort modes in a drop-down list. The list shows the currently selected sort mode and allows you to switch to other modes. Global Sort Only: If your business scenario only requires a global sort, select this option to simplify the interface. Viewers can click the up and down arrows to switch between global ascending, global descending, and no sort. In-group Sort Only: Select this option if your business scenario only requires an in-group sort. Viewers can click the up and down arrows to switch between in-group ascending, in-group descending, and no sort. No Sort: Disables sorting.
  	Mobile: Supports All Modes, Global Sort Only, In-group Sort Only, and No Sort. The sorting logic is the same as on a PC.
  Merge row dimension	Merges row dimension information into a single column. You can also configure the following settings: Row dimension name: Enter a name for the merged row dimension column. Row dimension width: Set the width of the row dimension column. You can select Auto or enter a custom width. Show row dimension field in data: Select this option to display the name of the row dimension field. Dimension layout: Set the text layout to horizontal or vertical after the rows section is merged. Note You can configure the row dimension merge settings for PC and mobile separately. Click the icon at the top of the page to switch between platforms.
  Show sparklines	If the Columns area contains a date field and the Rows area contains a measure, you can show a sparkline. If you enable this feature, you can customize the name of the sparkline.
  Show row numbers	If you select this option, row numbers are displayed in the report. ① You can set a name for the row number column. ② You can select Do not show row numbers for total rows. Note The Do not show row numbers for total rows option is available only when column totals are enabled for the cross table.
  Pagination	Click the pagination icon to open its settings. The default pagination mode is Normal. If there is a large amount of data, we recommend that you select Simple mode, which does not calculate the total number of data entries. For the pagination type, you can select First-row dimension or All dimensions. Note When you perform a global sort, first-row dimension pagination is automatically disabled. You can set the number of items per page to 10, 20, 30, 50, 80, 100, 200, or 500. The default value is 20.

• In the Table Head section, configure the styles for the row and column headers of the cross table.

  

  Parameter	Option	Description
  Column header	Hide column header	Hides the column header.
  	Background	Set the background color for the column header.
  	Text	Set the text style for the column header.
  	Set alignment	Set the alignment for the column header. Options include left, center, and right.
  	Custom measure header name	If a measure is used as a row dimension, you can set a custom header name for the measure.
  Row header	Background	Set the background color for the row header.
  	Text	Set the text style for the row header.
  	Set alignment	Select this option to set the alignment for the row header. This setting overrides the alignment setting in the field configuration. For example, if the Profit Amount field is set to left-aligned in the field configuration, but you set the alignment to center-aligned here, the field name in the row header will be center-aligned.
  	Wrap row header text	If you select this option, long text in the row header area is automatically wrapped.

• In the conditional formatting section, set conditional formatting rules for your data.

  

  Parameter	Description
  Series	Select a field to apply conditional formatting to. You can choose any field that has been added to the data panel. To remove configured conditional formats, click Clear Formats in Batches at the bottom right of the field panel. In the dialog box, select the formats to remove and click Confirm.
  Quick style	Choose a predefined style to set the icon or font color for the field. Quick styles apply only to measure fields, not dimension fields. Comparison: You can choose to Compare with 0 or Compare with average. Two-color Fill: Selects the color for the data bar. Note The length of the data bar is calculated as follows: If the maximum and minimum values include both a positive and a negative number, the denominator is the maximum of their absolute values. If the maximum and minimum values are both positive or both negative, the denominator is the difference between their absolute values. Color Scales: Choose from Gradient, Two-tier, or Three-tier. Invert colors For a comparison, if values less than 0 are red and values greater than 0 are green, inverting the colors makes values less than 0 green and values greater than 0 red. Clear: To remove a quick style, click Clear.
  Custom style	In addition to quick styles, you can configure custom styles for both measure and dimension fields, but the available options differ. Measure fields: Configure Text/Background, Icon, Color Scales, and Data Bar. Text/Background: Configure rules to highlight the text or background color of field values to visually emphasize key data.Configure the following information: Based on field: Set which data field the conditional rule applies to. By default, this is the field selected in the Series section. You can also select another field in the chart to create more complex conditional rules. Condition: Set the comparison basis for the rule. You can choose to Compare with a fixed value, Divide by percentage range, or Compare with a dynamic field. Rule: Set the specific logic for the rule and the display style for the cell text or background when the rule is met. You can set the text color, bold, italic, and background color. Add rule: Click to add a new rule. More settings: Set whether to hide the text of the current field and whether to apply the background color to the entire row. Icon: Display specific icons in cells based on a numerical comparison to clearly show the relationship between the current data and a target value.Configure the following information: Based on field: Set which data field the conditional rule applies to. By default, this is the field selected in the Series section. You can also select another field in the chart to create more complex conditional rules. Condition: Set the comparison basis for the rule. You can choose to Compare with a fixed value, Divide by percentage range, or Compare with a dynamic field. Rule: Click the Icon selection box to choose an icon set and set the logic for each icon. You can also select a specific icon for each comparison rule. Add rule: Click to add a new rule. More settings: Set whether to hide the text of the current field. Color scales: Change the background color of cells based on their numerical values to clearly show data distribution and trends. Note You can configure color scales only if Text/Background, Icon, and Data Bar are not selected. Configure the following information: Condition: Set the comparison basis for the rule. You can choose to Compare with a fixed value or Divide by percentage range. Rule: Set the color scale style (Gradient, One-tier, Two-tier) and specify the maximum, minimum, and boundary values, and their corresponding colors. In More settings: Set the shape of the color scale bars and whether to hide the text of the current field. Data bar: Represent numerical values with visual bars to more intuitively show relative sizes or comparisons.Configure the following information: Rule: Set the display rule for the data bars of the current measure field. You can specify a different color for each rule. Add rule: Click to add a new rule. Customize max/min: If you select this option, you can specify custom maximum and minimum values. In automatic mode, the maximum and minimum values default to the highest and lowest values in the current field. More settings: Set whether to show the data bar background and customize its color. You can also set whether to hide the text of the current field. Dimension fields: Configure Text/Background and Icon. Text/Background In the Rule section: Set the conditional rule to highlight the text of the current dimension field. This condition is based on the dimension value, so you can only enter text in the condition value input box. In the More settings section: Set whether to hide the text of the current field. Icon In the Rule section: Set the icon marking rule for the current dimension field. This condition is based on the dimension value, so you can only enter text in the condition value input box. In the More settings section: Set whether to hide the text of the current field.
  Apply conditional styles to summary data	Choose whether to apply conditional styles to summary data. If you select this option, the calculation of maximum, minimum, and percentage values in the conditional rule will include subtotal data but not grand total data.
  Synchronize style to	Synchronize the current conditional format to other fields.

• In the Totals section, set columns and rows totals for the required dimensions.

  • Columns: Calculate summary data by column. This option is unavailable if the cross table does not contain measures or row dimensions.

  • Rows: Calculate summary data by row. This option is unavailable if the cross table does not contain measures or column dimensions.

  

  Parameter		Description
  Columns	Position	Set the display position for column grand totals and subtotals. You can choose to place them at the Bottom or Top of the summarized data.
  	Overall summary (column grand total)	Click the switch to enable or disable column grand totals. When enabled, this performs a summary operation on all values in a column. You can also configure the following settings. Total alias: You can set a display name for the grand total, such as "Total Sales for All Regions." Calculation method: Select a uniform aggregation method for all fields. If a field is a calculated field, the selected aggregation method does not take effect, and the original aggregation method is used. If you need to set a different aggregation method for each field, select Custom from the drop-down list and configure the aggregation logic for each field in the Custom Functions module. Style configuration: Set the text style for the grand total. You can use the system default or customize the text color, background color, font weight, and more. Pin to top: Set whether to pin the column grand total to the top. Note If the column total is pinned, you cannot copy the summary data.
  	Categorical summary (column subtotal)	Click the switch to enable or disable column subtotals. When enabled, it calculates a subtotal for each category within a column based on a selected dimension. You can also configure the following settings. Subtotal alias: You can set a display name for the subtotal data, such as "Subtotal for Northeast Region Sales." Summary dimension: Set the dimension for categorizing subtotals, for example, to calculate a subtotal for the sales of each product type. Subtotal function: Select a uniform subtotal aggregation method for all fields. If a field is a calculated field, the selected aggregation method does not take effect, and the original aggregation method is used. Add subtotal: To view subtotals for multiple dimensions simultaneously (for example, subtotal sales for each product type and each region), you can click Add Subtotal to add another subtotal dimension. Style configuration: Set the text style for the current subtotal data. You can use the system default or customize the text color, background color, font weight, and more.
  Rows	Position	Set the display position for row grand totals and subtotals. You can choose to place them to the Left or Right of the summarized data.
  	Overall summary (row grand total)	Click the switch to enable or disable row grand totals. When enabled, it performs a grand total operation on all values in a row. You can also configure the following settings. Total alias: You can set a display name for the grand total, such as "Total Sales for All Products." Calculation method: Select a uniform grand total aggregation method for all fields. If a field is a calculated field, the selected aggregation method does not take effect, and the original aggregation method is used. Style configuration: Set the text style for the grand total. You can use the system default or customize the text color, background color, font weight, and more.
  	Categorical summary (row subtotal)	Click the switch to enable or disable row subtotals. When enabled, it calculates a subtotal for each category within a row based on a selected dimension. You can also configure the following settings. Subtotal alias: You can set a display name for the subtotal data, such as "Subtotal for Northeast Region Sales." Summary dimension: Set the dimension for categorizing subtotals, for example, to calculate a subtotal for the sales of each product type. Subtotal function: Select a uniform subtotal aggregation method for all fields. If a field is a calculated field, the selected aggregation method does not take effect, and the original aggregation method is used. Add subtotal: To view subtotals for multiple dimensions simultaneously (for example, subtotal sales for each product type and each region), you can click Add Subtotal to add another subtotal dimension. Style configuration: Set the text style for the current subtotal data. You can use the system default or customize the text color, background color, font weight, and more.

  Note

  For frequently asked questions about configuring totals, see 1. FAQ about totals.

• In the Filter section:

  • If you select Enable field filter display, you can click the Selected Fields drop-down list on the cross table in preview mode to filter or sort fields.

    

    If a Form Fill-in event is configured and you deselect a field that is bound to the fill-in form, the form fill-in will not work correctly. For more information, see Map field relationships.

    • You can set default selected dimensions.

      

    • You can set the maximum number of selectable dimensions.

      

      For example, if the maximum number of selectable dimensions is set to 6, you can select up to 6 dimensions to display.

      

  • If you select Enable quick filter, you can click the Filter drop-down list on the cross table in preview mode to filter fields.

    

    To filter multiple fields at the same time, you can add multiple conditions in the dialog box that appears.

    Example: Analyze the city distribution in the South China region where the shipping cost is > 300 and the discount rate is > 0.5.

    Note

    Filter conditions applied in preview mode are not saved by default. When you close and reopen the page, you need to reapply the filter conditions.

• The Auxiliary Display section lets you set the scroll bar display mode and the scroll bar thickness.

  • If you set the display mode to Show on hover, the scroll bar appears only when you move your pointer over the table.

  • To make the scroll bar always visible, select Always Show.

    

  • To make the scroll bar more prominent, you can adjust its thickness.

    

Cross table styles

You can adjust the following settings directly on the cross table:

• Click a column to open a drop-down list of configuration options.

• Adjust the number of records per page.

• Drag a column edge to adjust its width.

Configure chart analysis

Export data

You can export data only when the export feature is enabled. For more information, see Configure the export feature.

Secondary indicator

Once a measure is configured, you can enable and configure a secondary indicator.

After you select Display Secondary Indicator, you can select any measure from the comparison indicator drop-down list.

• Comparison Date: You must select a date field.

  Note

  • If the chart contains a date field, you can only select the one with the finest granularity for comparison.

  • If the chart does not contain a date field, you can select any date field from the dataset.

• Comparison method: The available comparison options are determined by the granularity of the date field. A maximum of four options are displayed. For example, if you select daily granularity for Comparison date, the Comparison options are Day-over-day, Week-over-week, Month-over-month, and Year-over-year. If you select monthly granularity for Comparison date, the Comparison options are Month-over-month and Year-over-year.

• Comparison Indicator: Select a measure on the dimension to use for comparison.

• Show: By default, Percentage difference is selected. Other options are Difference and Original value.

  • Difference: The data is displayed in the same format as the measure.

    When this option is selected, you can also select Calculate the Difference Between Percentages. By default, this option is not selected. If you select it and the measure is a percentage, the difference is automatically displayed in percentage points (pt). For example: 5.2% - 4.1% = 1.1pt. You can set the number of decimal places to 0, 1, or 2.

  • Percentage difference: You can set the number of decimal places to 0, 1, or 2.

• Period-over-period comparison (daily granularity filters only): When enabled, the filter condition is applied to both the current and comparison periods. For example, if you set a filter for 2022-01-02, a year-over-year comparison will also apply a filter for 2021-01-02. This feature is supported for day-over-day comparisons but not for dynamic ones.

• When previous period data is negative: Specify the formula for calculating the percentage difference when the previous period's data is negative. The options are:

  • (current period data / previous period data - 1) * 100%: This is the default formula.

  • 1 - (current period data / previous period data) * 100%

  • Display as -

• Synchronous Comparison Indicator: You can apply the current indicator's configuration to other indicators.

• Display Location: By default, Right Side of Indicator is selected. Other options are Right and Below Indicator.

  • Right Side of Indicator: Adds a new column to the right of the current measure. The column name is based on the comparison method you selected, e.g., year-over-year, day-over-day, or month-over-month.

    If the measure is in a column, the secondary indicator is displayed to its right.

    

  • Right: Displays the comparison measure in a separate column to the right of the current measure.

    • If the measure is in a column, the last column dimension is split to show the comparison values for each selected method, e.g., day-over-day, week-over-week, month-over-month, and year-over-year. This splits the dimension value into multiple measures, displayed to the right of the current measure, as shown in the figure below.

      

    • If the measure is in a row, the last row dimension is split to show the comparison values. The behavior is similar to a column-based measure, but the comparison values are displayed below the measure instead of to its right.

      

  • Below Indicator: Adds new rows below the current measure to display the comparison values. The alignment is consistent with the primary measure: text is left-aligned and numbers are right-aligned.

    The comparison values are displayed in the same column as the primary measure. A new row, named after the comparison method (e.g., day-over-day or week-over-week), is added below the primary measure's header.

    

• Display Style: Choose a color scheme for positive and negative numbers from the following options: Follow global semantic colors (configured in Page Settings > Global Styles > Semantic Colors), Red for positive, green for negative, or Green for positive, red for negative.

1. Calculating totals and subtotals

Calculation logic for totals

• If your original metric is GMV (sum) and the calculation method for totals and subtotals is set to auto (the default), the system calculates both the total and subtotal as GMV (sum). If you change the total calculation to custom and select average as the aggregation method, the system calculates the total as GMV (average).

• If your original metric is id (count distinct) and the calculation method for totals and subtotals is set to auto, the system calculates both the total and subtotal as id (count distinct). If you change the total calculation to custom and select count as the aggregation method, the system calculates the total as id (count).

How to calculate a ratio

1. Define the ratio.

   For this example, assume the ratio is defined as (metric A / metric B).

2. In your dataset, create a calculated field and define its expression as rate = sum(A) / sum(B).

3. In the data pane on the dashboard, select the rate (sum) metric. When you enable totals and subtotals with the default auto setting, the total and subtotal are correctly aggregated as sum(A)/sum(B).

   Note

   • If you write the expression in the dataset as rate=A/B, enabling totals and subtotals with the auto calculation applies sum(A/B) logic, which can produce incorrect results, such as a ratio greater than 100%.

   • To enable the parent column summary percentage, two conditions must be met: First, place measures in the Rows area and dimensions in the Columns area. Second, the Columns area must contain two or more dimensions.

2. Conditions for parent column summary

The parent column summary percentage applies if the following two conditions are met:

• Place measure fields in the Rows area and dimension fields in the Columns area.

• The Columns area must contain two or more dimension fields.

3. Creating a calendar in a pivot table

You can create a calendar-like effect by applying conditional formatting. First, apply a rule to the week number field to hide its text. Then, apply another rule to the date field to display different colors for different values.