| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot's table problem
I have follow pivot tabel:
NAME VALUE1 VALUE2 401001 50 60 401002 60 30 401022 40 10 411011 10 3 411013 70 30 426022 10 30 ..... How count subtotal of main type account in VBA? result: NAME VALUE1 VALUE2 401001 50 60 401002 60 30 401022 40 10 401999 150 100 'sum of 401001÷401022 411011 10 3 411013 70 30 411999 80 33 'sum of 411011÷411013 426022 10 30 etc. accounts I work in excel 2k. Can anyone provide me with the code? Regards Mark |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
pivot's table problem
You sims to come from Poland :-) try to prepare an atribute of 3 first chars of an account to another separated field of database SELECT LEFT(Field,3) AS Field3, * FROM ... and make PivotT again.
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
pivot's table problem
You right!
It might by solution of my problem. Regards from Poland Mark -----Original Message----- You sims to come from Poland :-) try to prepare an atribute of 3 first chars of an account to another separated field of database SELECT LEFT(Field,3) AS Field3, * FROM ... and make PivotT again. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table problem | Excel Discussion (Misc queries) | |||
| Table problem | Excel Discussion (Misc queries) | |||
| Pivot Table in Excel 2007 : Problem with % in Table | Excel Discussion (Misc queries) | |||
| look up table problem | Excel Worksheet Functions | |||
| Problem with pivot table | Excel Discussion (Misc queries) | |||
![Mark[_17_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
