Skip to Main Content
Status Future consideration
Categories Reports
Created by Jonathon Leeke
Created on Sep 2, 2016

Cells in Pivot Reports should align, like a table

Using the "Show Cell Headers" option in a Pivot Report is a nice way to include additional feature details in the view.  However, if the text wraps or if you have blank values, the features and their details will become misaligned, since the pivot cells are not built as a table.  It just slaps horizontal lines between each value to build a quasi-table view, which is not effective and severely limits the usefulness of showing cell headers.  Please update Pivot Reports to act more like tables and keep cell values aligned!

  • Attach files
  • Avigail Ehrenhaus
    Reply
    |
    Apr 24, 2023

    This is not an enhancement. This is a bug.

  • Kole Hainz
    Reply
    |
    Feb 20, 2023

    I am trying to create a pivot report almost identical to the one in the original post and still seeing the misalignment issue.

    Curious if anyone has more details on Jerrold's comment below that "it appears that the report itself now formats correctly." Are you still setting up pivot using cells? Or is there a different way to do this to keep cells aligned?

  • Jerrold
    Reply
    |
    May 5, 2021

    Following up on this 2 years later, it appears that the report itself now formats correctly, however, when added to a dashboard, the formatting reverts to the original issue. Additionally, when adding the report to a Presentation, the format is also fixed - it seems this is only 'broken' when adding it to a dashboard. My position in the my post back in 2018 has not changed - this should be considered a defect, not an idea or an enhancement request. This is tabular data, and I believe it is reasonable to expect that tabular data is aligned. I'm attaching two images, one showing the formatting in a report (working), the other in a dashboard (broken).

  • Jonathan Lewit
    Reply
    |
    Jan 20, 2021

    I have also run into this, trying to create a detailed "above the line" report for our executive team. If it was possible to "force row height" or "create consistent rows" (like a table), that would address our need. Another options could be to provide options to "decorate" a list view report so that we could create the visual distinction. A standard list report doesn't provide the visual distinction possible with the pivot report. The pivot report enables better "chunking" of the data. I have considered using the card view on the features board, but we have projects that span workspaces.

  • Guest
    Reply
    |
    Aug 28, 2019

    The workaround will not work for us because we need to have the features and their status grouped by release date.  How do I line it up in this case?

  • Ron Yang
    Reply
    |
    Nov 30, 2018

    Thank you for the additional comment here. There is a workaround which will help to better align the report. Using the example attached to the idea, if you move the Feature to appear as a "Row" instead of a "Cell," this will align the data in the way that you would expect.

  • Jerrold Emery
    Reply
    |
    Nov 30, 2018

    Quite honestly, I find it a bit disconcerting that this item has been open for over two years. In my opinion, this is not a feature request, this is a defect. When data in reports do not align, providing them to stakeholders only leads to confusion. In fact, when I provided my screenshot to support, the initial response what that they do align, but that "The last record in your screenshot has 4 tag values so that entire row is larger to accommodate the 4 values. " It wasn't until I provided a screenshot identical to the one on the OP that I was asked to upvote this feature request.

  • +1
5 MERGED

Fix Misaligned Pivot Reports

Merged
Users have been increasingly frustrated by Pivot reporting. Cells never line up which leads to confusion. (example image) Please redesign the report so that all related data is in-line & easily read/understood.
Guest over 4 years ago in Reports 0 Future consideration
3 MERGED

Allow Pivot Table Rows to remain aligned

Merged
Currently, when pivot reports generate with tags in their own column, then the rows between columns do not remain aligned. It creates confusion on what tag is applicable to which item. In the attached example. There is no tag on the last item on...
Guest over 4 years ago in Reports 0 Future consideration