Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Gen pivotcache with data filtering/conversion
I've done a lot of excel/vba work but am at a loss as to how to create a
pivotcache (- pivottable) with filtering and data conversion from an existing querytable simply. Here is the example: I have a querytable with a date column and other data. I want to generate a pivot on this data for a given date range and slice and dice by month. I don't want to have to filter the data and normalize the date procedurally, nor do I want to affect the source querytable. What's easiest? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Increase Your Business By Data Conversion, Data Format and Data EntryServices in India | Excel Worksheet Functions | |||
How do I tell the pivot table to ignore the PivotCache and go straight to the data in ConsolidationReference | Excel Programming | |||
Query data within a PivotCache programmatically | Excel Programming | |||
PivotCache Data Source | Excel Programming | |||
Re-create source data from pivotcache | Excel Programming |