Pivot how run the pivot table with examples

David, what you're looking for is pivot table functionality. Unfortunately, that is not a built-in feature for MySQL (it is for SQL Server 2005/2008).
Not knowing your table structure, or the size/number of rows/columns, I found the following link to be most helpful example: MySQL Pivot Table Example

Hi

Here are a couple of solutions

Solution A
-click a cell on your active pivot,
-right click, check "grand total for columns" / "rand total for rows"


Solution B
-click on tools customize
-check box "pivot table"
-click on the Pivot Table Tab, down arrow,
-click on Subtotals


regards,
=)

http://www.ehow.com/how_6819320_build-pivot-table.html

My suggestion is to use a Pivot Table.  Follow these instructions:
Click on column A1 - then in the menu bar click DATA > Pivot Table and Pivot Chart Report.  

Click NEXT on step 1 of pivot table wizard.
For step two you will want to highlight all of the data on your sheet.  then click next.
Choose NEW WORKSHEET for step 3 of the pivot table wizard and click finish.
Once the Pivot Table sheet opens, drag the STATUS field into the top left corner of the pivot table view, where "drop column fields" and "drop row fields" meet.  Next drop another instance of the STATUS field into the "drop row fields here" column.  And lastly drop the OWNER field into the "drop column fields here" section.  You should now be viewing a report showing you exactly what you were looking for.
Regards,
Joe

Use this link for pivit tables
http://office.microsoft.com/en-us/excel/HA010346321033.aspx

Use this link for Mail Merge:
http://www.excel-tutorials.org/worksheets/how-to-create-a-mail-merge-using-microsoft-excel-and-word/

Can you do this using a pivot table where columns B & C are Row Fields and Count of B&C is data fields.

Suppose you have a Database regarding sales of this Month inthe Column and Row Fromat with column Heading SalesPerson, Company, Product and Amount. where salesperson sales to different company different Products more than once. In this type of Database Salesperson, Company and Products appears more than once. Now you can use PivotTable to view and analyze your data in different Formats like Salesman wise COmpany wise and Productwise with different formatting REports with a facility of Preparing Charts too.

Hi, Pivot tables are quite complex but basically you have a table of data which you sort based on different fields from your table.

Send me your email address and I will email you further instructions with an attached example file ok.

Regards
SeaJade

You need to create subtotals so that it looks like something like this:

Prod/units Amt. Level Total

xxxx 10.00 1
yyyy 20.00 1
30.00

dddd 40.00 2
ffff 30.00 2
70.00

etc.

To do this I would suggest using the Pivot Table feature of Excel. It is not too hard to use but you do have to know what you want and also have to be sure you are getting results as expected. Like any tool, it has to be used right. You can also use sub-total functions supplied in VBA as well in your cells.

If you want to avoid using VBA functions in cell and deal with ranges, etc., use the Pivot Table Wizard.

Some reading:
http://www.ehow.com/how_13020_pivot-table-wizard.html
http://www.microsoft.com/dynamics/using/excel_pivot_tables_collins.mspx
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

Also Google "Excel pivot table wizard" to get more.

Good luck!

Highlight the entire pivot table and name it as a range. Then in the formula, replace the reference to the table addresses with the range name. Then wherever you move the table (move, not cut and paste) it will automatically gather the right data. Thanks for rating FixYa!