| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivottable
I have vba code that creates a pivottable with an
external informix database as the source. Part of the SQL statement is listed below: SELECT loc_id, ........ invt_mthend_qty*invt_avg_cost FROM informix.grp_name grp_name...... WHERE item.item_grp_nbr = grp_name.grp_nbr ...... When the code attempts to calculate the pivottable, the field "inv_total.invt_mthend_qty*invt_avg_cost" is inconsistently displayed as inv_total.invt_mthend_qty*invt_avg_cost OR EXPR. Any thoughts on why the reference is not consistent? Thanks Fred |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PivotTable | Charts and Charting in Excel | |||
| Creating a PivotTable w/o selecting data in an existing PivotTable | Excel Discussion (Misc queries) | |||
| PivotTable | Excel Discussion (Misc queries) | |||
| PivotTable - PivotTable Field name is not valid - error! | Excel Programming | |||
| Creating a PivotTable Report from an Another PivotTable Report | Excel Programming | |||
Threaded Mode
