It'd be great if we can have multiple calculation options to the grand total for rows and columns. In other words, get grand totals to show not just the sum but also give the ability to count, average...etc1 vote
Kenneth beat me to it, but this is already possible today with Excel – the Grand Total will show whatever aggregation you’re using for the column. To change that,
1. In the PivotTable Fields pane, click on one of your fields in the Values section.
2. Choose Value Field Settings.
3. In the scrollable list that appears, choose a calculation type other than Sum.
Hope that helps,
I always have to resize the columns after refreshing.
I have some instances where i have to refresh after changing input and i have 2 grids below the pivot and any time i refresh it messes up the column widths so i have to keep resizing. It is annoying. Add a way to lock the column width so this wont happen every time i refresh.1 vote
This is already supported. After you initially create the PivotTable, you can do the following:
1. right click on the PivotTable and choose PivotTable Options…
2. On the Layout & Format tab, make sure that “Autofit column widths on update” is unchecked.
In the future, The best place to ask this question is the Excel area of answers.microsoft.com – specifically the Windows Excel Desktop area ( http://answers.microsoft.com/en-us/office/forum/office_2016-excel-os_device_win10desk?sort=lastreplydate&dir=desc&tab=threads&status=all&mod=&modAge=&advFil=&postedAfter=&postedBefore=&threadType=all&tm=1456878400400&auth=1 )
We’ve got folks over there who can help with questions like this, and we’re trying to keep the UserVoice site for new product ideas.
Hope that helps,
Please make functionality "improvements" with the ability to choose when to use them. Excel now "auto-groups" certain data in pivot tables. I don't need or want this most of the time, but I can't turn it off. Now I'm in a bind where I need to process several reports and have to figure out how to work with this new forced "enhancement"1 vote
Good news – this is already supported in Excel. To turn off Date Grouping in PivotTables, go to File > Options > Advanced, scroll down to the “Data” section, and toggle the “Disable automatic grouping of Date/Time columns in PivotTables.”
- Don't see your idea?