# Excel 2010 Pivot Tables

## Excel 2010 Pivot Tables

I have created a pivot table with each month as the main category and a product line as the row with the amount sold going into the sub columns (each week) - and the whole year is totaled. but I have hidden the weeks so you can only see the month. I tried adding a percentage on the end of the pivot table - because I wanted to see the percentage of each product sold - but everytime I go to "maximize" the weeks in the month the percentage column disappears. So my question is - is there anyway to not to "maximize" all the weeks of each month - then going in manually and hiding them? and be able to show the percentage of each month?

Visit publisher's web-site: Excel 2010 Pivot Tables

## Related Tutorials

### Pivot tables

In my work as developer I normally need to transform data from one format to another. Typically our data input are a database and we need to show database data into a report, datagrid or something similar. Its very typical to use 'pivot tables'. I want to write a class to 'pivot tables' in PHP with the most common requirements (at least for me )

### Pivot tables 2010 - summarize values by

Can someone tell me how to change the 'Summarize Values By' from Sum to Average for an entire column or row simultaneously? Presently, I am making the changes by individual cells.

### Pivot table - change data source to another pivot table in 2010

I have a page with 8 pivot tables looking back to the same source data. In Excel 2003 I used to be able to change the data source for tables 2-8 to point to table 1 which reduced the file size quite a bit, but I can't see how to do this in Excel 2010 -

### Refreshing Pivot Tables

I have one set of data and several pivot tables created using this data all in the same workbook (each pivot table has its own tab) When refreshing the pivot tables I need to be able to refresh only one pivot table at a time, and the problem is that sometimes several pivot tables are updated after refreshing only one. This is needed because some of the pivot tables contain information that is updated only quarterly, yearly, etc. How do I ensure that all the pivot tables are set up correctly so that only one is refreshed

### Pivot Tables Refresh...kinda

I have a workbook that has 6 connections to an MS Access database. When I use the command "RefreshAll" in vba the linked tables refresh, but the pivot tables and pivot charts that are based on them do not. If I run the macro again, then the pivot tables and charts update.

I have tried calling the sub twice from another sub, but that doesn't work. I have also tried to use the code:

ThisWorkbook.RefreshAll

and then looping through all the pivot tables and refreshing. Again, the data tables refresh but the pivot tables and charts do not.

## Related Applications & Scripts

### Premium Pricing Tables Plugin

WP Mega Tables are the perfect solution for those who are in need of a well designed and more importantly a easy to use pricing table in there wordpress themes.

Looking for such a plugin?, then look no further because wptitans has the answer. A pricing or information table with a clean and elegant look and the most important thing is that the tables are so easy to manage and very flexible. The tables can be added as 1, 2, 3, 4 and even 5 columns, this depends of course of the width of the page your adding the tables.

### Responsive Clean Simple Pricing Tables

A set of gorgeous clean responsive pricing tables. Coming in 7 different color variations, these tables will shine on your website.

What you get

- Clean Simple Design

- 7 Color Variations

- Built with CSS3

- Fully Responsive

- CSS3 Slide Animations

- jQuery Fallbacks

- All major browsers

- Easy to use

- Other colours available upon request

### Manage MySQL database tables

This class can be used to manage MySQL database tables. It extends the MySQLi base class to add new functionality like:

- Inserting, updating and retrieving MySQL table rows from a list of parameters

- Creating and dropping databases, tables and triggers

- Adding table columns

- Retrieving table comments

### MySQL CSV Dump

This class can be used to dump MySQL tables into compressed CSV files.

It can query the values of the records of the tables of a given MySQL table and generate CSV files with table contents. By default it dumps all database tables, but it can exclude a list of given tables.

The class can gather all dumped CSV files and compact them in a ZIP archive.

### CSS3 Vertical Web Pricing Tables For WordPress

This is a pack of pure CSS3 Vertical Web Pricing Tables For WordPress. Tested and working in all modern browsers.