Skip to Main Content

Share your product feedback

Status Future consideration
Categories Reports
Created by Austin Merritt
Created on Jul 14, 2020

Format values in summarized pivot cells

When creating a pivot table, you can choose to summarize the values in the cells using the "Within cells list as" option. In some cases, the summarized values need formatting.

For example, if you have a list of percentage values in your cells and you choose to calculate the average. It would be great to be able to set the summarized value to be a percentage as well.

  • Attach files
      Drop here to upload
    • +3
    6 MERGED

    Apply percentage formatting when fields with that underlying format are used in a calculated view on a pivot table

    You can create calculated fields with percentage formatting in a list view. When converting to a pivot view, these fields retain their formatting if you set the pivot to "List records" but lose it if you change that to Sum or Average values. If al...
    Maria Plotkina 6 months ago in Reports 0 Future consideration
    14 MERGED

    Add Percentage to Roadmaps > Analytics > Pivot

    As part of the Roadmaps Analytics pivot reports the Cells "within cells" computations is missing percentage. This should be included and along with the other existing computations on cells. See attached image.
    Clark Milner over 5 years ago in Reports 10 Future consideration