Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate Formulas in Excel 2000 Pivot Table
I would like to create a formula within an Excel 2000 Pivot Table. This is the scenario: Row contains Product Column contains Region Data contains Sum of Sales There are automatic grand totals on the column and row The formula I want to create will divide the total sales of each product into the grand total sales figure to provide a % of sales. Using the calculate formula, I can select the Sales field, but am not able to reference the Grand Total for sales. By researching on the Internet, I understand that there is a GETPIVOTDATA funtion available, but it is only for Excel 2002 and higher. Any suggestions? By the way, my data source will be via an ODBC driver to a SQL database. Christina -- Christina |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2002 - Pivot Table : Can I divide instead of sum ? | Excel Discussion (Misc queries) | |||
Excel 2000 pivot table problem | Excel Worksheet Functions | |||
create pivot table from excel table | Excel Worksheet Functions |