With the tables, if the header is not visible, Excel displays the headers of the table in the columns headers (see the picture attached)

It will be great to have the same behaviour with the pivot tables

There are times when I need to add a column to a pivot table that just shows the value from the field without calculation. For example, part number and part name. I will setup the the pivot table to summarize by part name, but I need the part number to show up in a column, not as a sub-item of the part name in the first column.

Set our pivots to automatically default to a specific format, i.e., accounting? Regardless of the number format, the pivot is always a general format that I have to change to accounting. To be able to set a default format would save time!

Users should be able to organize measures in folders and subfolders when configuring a Power Pivot using Excel's data model. This would be similar to the functionality available in SSAS Tabular.

It would be very flexible to be able to deconstruct pivot table into basic worksheet. This should break the connection and all pivot table propertiies. Of course it would be irreversible.

Pivot Table: Value Field Setting

Show just the value (no stats). Remove "Sum of", "Count of" from pivot tables and charts.
Pivot Tables are Fantastic Tools to quickly filter and display data, but I have to run VBA every time I do a new selection to remove the wording "Sum of..." or what ever the default is...
Please assist
Thank you
John Murray

In the pivot tables' options, there's a checkbox called "For empty cells show..." along with a textbox. Whatever the checkbox's or the textbox's values are, empty cells all display (Empty) in our pivot tables. The pivot tables should respect the user's choice.

I'm having this issue right now and it's a major limitation. I've seen this in support forums from years ago: https://answers.microsoft.com/en-us/msoffice/forum/msofficeexcel-msowin10-mso_o365b/sort-pivot-when-you-have-a-difference-from-value/280c1272-703e-4399-8e71-6d7feddfd111

Please give us the option to allow a pivot table to MOVE another pivot table when the first pivot table is expanded, so as to avoid an overlapping range conflict.

Tables (listobject) already work this way. I.e. if I have two tables, one is on top of the other, and I continue adding rows to the first table, it will automatically move the second table further down the page. Why cannot pivot tables do the same thing?

Pro Plus Excel 2002 12527.21104 connect to prostgresql return below error message. rollback to previous version. problem is gone.

There should be option of count of all and unique values in pivot table

Allow the user to set defaults for pivot table formatting. For example, in most of my reports, I want data to be formatted with two decimal places, a comma between thousands, and negative numbers to be shown as red with parentheses. Today, I have to manually do all that formatting for each new pivot table and my formatting gets reset whenever I drag the field from one quadrant to another. Please allow these to be preset and persist.

When an existing Excel Table is Resized, and a Pivot Table is inserted using this newly defined data range, the new Pivot Table does not include the columns newly added to the Excel Table, until the newly created Pivot Table is Refreshed.

On Insert --> Pivot Table, the newly inserted Pivot Table should reflect the current state of the defined range, instead of a cached version.

Filter arrows should be able to be hidden in all tables (including PivotTables). This is especially applicable when using linked tables in a PowerPoint presentation.

In the PivotTable Options > Display menu there is a checkbox for "Display field captions and filter drop downs". This should be split into two options: "Display field captions" and "Filter drop downs", with Filter drop downs having two sub-boxes: "Remove filtering" and "Show filter arrow when hovering". This would make the filtering arrow only appear when the curser was hovering over the box or it was the active cell.

It should be possible to name the new worksheet from the "load to…" function in Power Query. Any table that is created inherits the name of the query that produced it, but the worksheet always receives a default "Sheet1". For my purposes, inheriting the query name would be sufficient. Others may wish to name it from within PQ.