View Single Post
Old 03-14-2011, 06:53 AM   #1
titejj52
Sergeant First Class
 
Join Date: Mar 2011
Posts: 113
titejj52 is on a distinguished road
Default cheap office 2010 key Calling all PivotTable users

number of months back again I wrote a number of posts about the improvements that we made to PivotTables in Excel 2007. I even showed how summarizing data in different ways is now just a right click away on the “Summarize Data By...” menu. What I didn’t show was that in addition to these standard ways of summarizing data (sum, count, max, min, average,microsoft office Standard 2010 license, etc.),office 2010 pro generator, Excel already supports some more complex summary views for items contained in a PivotTable. For instance, by selecting “More Options,” you can choose to show the data as a “Running total” or “% of Total.” given the data below in a PivotTable ... to enlarge) can choose to “Summarize Data By... > More Options” and then show the values as the “% of total”.... and Excel will automatically perform the calculation for you in the PivotTable. to enlarge) gotten a number of pieces of feedback about this functionality, usually that (a) it’s useful but hard to find, or (b) it would be more useful if there were additional options for how the data could be shown in addition to the ones listed in the dialog above. have someone on the team starting to look at this as part of our planning for future releases (the version after 2007), so we’d like to hear what you think. Here are some specific questions we would love to hear your answers to,buy office Standard 2010, but feel free to add additional commentary too. Have you ever used this feature in PivotTables?
If not, why not? (Might you use it now that you know about it?)
If so, what are the most common options that you choose,buy windows 7 update key, and what type of data do you use them with?
Perhaps most interestingly,cheap office 2010 key, are there additional options that you would like to see added (for instance - “% of parent” could show the percentage of an item to its parent group instead of to the column total)?
post your answers using comments, as it is easier for everyone on the Excel team to read comments (as opposed to the email link which sends email just to me). for your help.
titejj52 is offline   Reply With Quote

Sponsored Links