Skip to Main Content
Preset Feature Feedback
Status Shipped
Categories Enhancement
Created by Sunny Xu
Created on Feb 10, 2022

Customize Pivot Table or Time-series Table Format for Each Column

  1. What is the problem or goal the end user is trying to solve or accomplish?

    1. Be able to change the format to dollar vs regular number separately within a pivot table or time-series table

  2. How are they solving it currently?

    1. No formatting is applied, because a dollar D3 format will be applied to all columns, even though some columns aren't monetary

  3. What is the recommended solution by the Customer?

    1. Be able to customize per column the format for a pivot table or time-series table

  • Attach files
  • Admin
    Sophie You
    Oct 9, 2025

    This is now available for the Interactive Pivot Table. Use the Customize tab and look for the "Customize columns" section

  • Eric Eric
    Aug 12, 2025

    This issue is also seen in the new 'Interactive Pivot Table' chart type. It only allows 1 metric formatting, applied to all metrics. If you have 3 metrics - say a count (should be represented as an INT), an average (should be represented as an DECIMAL), and a percent (should be represented as 100*DECIMAL), this is currently not possible.

  • Mallory Reese-Bagley
    Dec 16, 2024

    I would note this needs to be able to be customized per column or row. In my particular use case, I'm pulling in multiple metrics in one time-series table. Some rows need different D3 formatting (see example screenshot, t

    One thing that would make this even better (and may require less UI work)--> if no D3 formatting is applied to a particular time series column, it should just inherit the D3 Formatting associated with the metric pulled into the chart. It's annoying to have to reconfigure the D3 formatting when I've already set the D3 Formatting for a particular metric at the dataset level.

  • +11
2 MERGED

Format each metric in a pivot table separately

Merged
In regular tables, you can default each metric column separately. However in pivot tables, you can only choose one number format for the whole table, which makes it difficult to show both counts and percentages with the formatting required for these.
Kristie Wirth over 3 years ago in Enhancement 0 Shipped