Ads
related to: pivot tables for dummies
Search results
Results From The WOW.Com Content Network
Hi, I have an assignment that involves pivot tables and I really can't get my head around these - I found an explanation from Dummies, but even that left me somewhat confused. I have a good understand of Excel, but just can't seem to grasp the mechanics of pivot tables. Many thanks.
First you can't stop Excel from giving the field the name Sum of. So where do you change the name? You can type it right over the name in the pivot table, usually the top left corner cell. Or you can right click the field in the pivot table and choose Value Field Setting and edit the Custom Name box. Follow Luke's suggestions regarding names.
With the pivot table select I chose Design, Layout, Show in Tabular Form. Then I type Michael Phelps into the Search box under Athlete and clicked OK. Then I right-clicked on one of the totals in column C (Event) and unchecked Subtotal Event. That's all there was to it in my case. I
Select a cell in the pivot table > Go to Pivot Table tab > Click the Select drop down and then check 'Entire table' and 'Labels and Data' > now copy and paste the content to a new workbook or new sheet. Click on Pivot table tab > Change source and then select the new data to check if it helps.
Pivot in Tabular format - As a general rule, I think Pivot Tables are best laid out in tabular format - Pivot Tables are sourced from tables, an I've found most people I've presented information to like seeing the Pivot's summary information in a similar way. To do this, go to the "Design" tab, at the far left, click on "Report Layout", then ...
I work with pivot tables regularly and a newly created table has data that is acting differently than the table that I created with similar data a few hours ago. A column that I have the actual date (MM/DD/YYYY) is only showing the month. A category of quarter is also showing up. I need to know how to get the actual date to show in my pivot table.
Hi. I have a list of data with columns Name, Amount1, Amount2, Amount3, Date. I would like to create a pivot table that shows the Amounts totaled by month and then by quarter and an YTD total.
At first sight this looks like the perfect use case for Pivot Tables, but a Pivot Table aggregates data, i.e. Pivot Tables always have numerical results in the value area. In other words, all you can show in the value area is the count of risks for each combination.
Now, over time, some of us are having the issue while others are not. Permissions have not changed. We also did try a test where I created a new pivot table, identical in property to the one with the issue right next to it. The new pivot table worked correctly, while the old one did not. When I refresh the new table - the old table also refreshes.
There is clearly a bug or something wrong with Excel - all of a sudden on more than one pivot table, in 2 separate files, some of my values are all displaying as 0's. When I click on these 0's in the pivot table, a sheet opens up with the actual values, so I know the data is there but for some reason its displaying it as a '0'.