Drill down pivot table data via VBA macro

Drill down pivot table data via VBA macro

Post by jmon7 » Mon, 24 May 2010 11:12:11



I am trying to create a macro that will drill down subtotals from
pivot table. Since the number of rows, and colums, changes frequently
need to reference the total for the row or column. Can this be done vi
VBA macro?


--
jmon76
------------------------------------------------------------------------
jmon76's Profile: http://www.yqcomputer.com/
View this thread: http://www.yqcomputer.com/

http://www.yqcomputer.com/
 
 
 

Drill down pivot table data via VBA macro

Post by Herbert Se » Tue, 25 May 2010 02:15:03

Excel 2007 PivotTable
Show subtotal details via macro.
Define subtotal with PivotFields.
http://www.yqcomputer.com/
Pdf preview:
http://www.yqcomputer.com/

 
 
 

Drill down pivot table data via VBA macro

Post by jmon7 » Tue, 25 May 2010 03:31:11


Herbert Seidenberg;729985 Wrote:
Excel 2007 PivotTable



hrm, that doesnt seem to work for me. I am posting a snip of my tabl
and code hoping you might see the issue.


+-------------------------------------------------------------------+
|Filename: MacroIssue.docx |
|Download: http://www.yqcomputer.com/ |
+-------------------------------------------------------------------+

--
jmon76
------------------------------------------------------------------------
jmon76's Profile: http://www.yqcomputer.com/
View this thread: http://www.yqcomputer.com/

http://www.yqcomputer.com/
 
 
 

Drill down pivot table data via VBA macro

Post by Herbert Se » Tue, 25 May 2010 05:02:51

In GetPivotData syntax,
you are missing Field1.
Added another tab to my example file,
simulating your multiple column layout.
Same link.
http://www.yqcomputer.com/
 
 
 

Drill down pivot table data via VBA macro

Post by jmon7 » Tue, 25 May 2010 05:08:57


Herbert Seidenberg;730004 Wrote:
In GetPivotData syntax,



I cant seem to access the file you loaded (and had the same issue las
time). Can you load a PDF like you did last time?

Thanks!


--
jmon76
------------------------------------------------------------------------
jmon76's Profile: http://www.yqcomputer.com/
View this thread: http://www.yqcomputer.com/

http://www.yqcomputer.com/
 
 
 

Drill down pivot table data via VBA macro

Post by Herbert Se » Tue, 25 May 2010 06:56:30

Pdf file, 3 pages:
http://www.yqcomputer.com/
 
 
 

Drill down pivot table data via VBA macro

Post by jmon7 » Tue, 25 May 2010 07:27:31


Herbert Seidenberg;730018 Wrote:
Pdf file, 3 pages:



got it now. Thanks!!!


--
jmon76
------------------------------------------------------------------------
jmon76's Profile: http://www.yqcomputer.com/
View this thread: http://www.yqcomputer.com/

http://www.yqcomputer.com/