Create Pivot from array?
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Date: Mon, 16 Feb 2004 09:51:09 -0800
Can it be done?
I want to extract data from a databsae to recordset via ADO, and then do calculations, before feeding it to a pivot table - can itbe done or am I just hoping?
Relevant Pages
- Re: Pivot Table Subtotal of Calculated Field Problem
... Pivot table formulas can work well for some calculations, but aren't too useful for summarizing line totals. ... FSUKC wrote: ...
(microsoft.public.excel) - RE: Create a pivot table via VBA code
... refresh the pivottable to use that data: ... have static data in a table (after using the CopyFromrecordset method), ... > from that I would like to place in the pivot table I have. ... So far, using ADO ...
(microsoft.public.excel.programming) - Pivot Table Question
... I'm trying to organize to perform some calculations in a Pivot Table, ... Average price per pound for each type of fruit and nut as well as the ...
(microsoft.public.excel.misc) - Re: Pivot Table refresh
... Assuming you have headers above your external calculations, ... in a row of the pivot table. ... the outside calculations and totals do nothing. ...
(microsoft.public.excel.misc) - PivotTable custom calculated total
... Matrix Detail LabID Analyte Result ... pivot table but it is my impression that custom ... calculations for totals are only possible in Access pivot ...
(microsoft.public.access.reports) |
|
