Add a new idea Subscribe
Status Shipped
Created by Suzanne Vaughan
Created on Aug 17, 2015

RELATED IDEAS

Merged idea

This idea has been merged into another idea. To comment or vote on this idea, please visit APP-I-1895 Headers on pivot tables.

Label Columns in Rows, Columns and Cells Merged

When adding columns to the target rows, columns or cells, you can't always tell intuitively what the value means. It would be extremely helpful to have the name of the columns as row or column headers. It'd be a good next step to add sub-column headers for feature data. For example: I am attaching a pivot table with some dates. I have no way of knowing what those dates mean unless I look at my "Select Data" screen. 

Select data.png
Pivot table.png
Select data.png
Open full size
Pivot table.png
Open full size
Select data.png Pivot table.png
  • Jonathon Leeke
    Reply
    |     Aug 28, 2015

    Sure, check out this screen shot.

    2015-08-28_11-1...
    2015-08-28_11-19-19.jpg
    Open full size
    2015-08-28_11-19-19.jpg
  • Suzanne Vaughan
    Reply
    |     Aug 28, 2015

    Hi Jonathan -- would you mind taking a screenshot of an example so we can more easily understand your request?

  • Jonathon Leeke
    Reply
    |     Aug 28, 2015

    I would also suggest to top-align the values in pivot cells.  When you have a pivot category with a lot of sub-categories, often the category name is below the fold, and you have to scroll down to see what the category is.  It would make more sense to top-align values within those large cells.