I am using the pivottable as a datasource for a series of other reports. The report is based on selecting data based on variables (the DSUM criteria) and I don't want to change the structure of the pivottable which would affect other reports reading from the same data (with different criteria). I am using a pivottable as a datasource to 'crosstab' the data from the underlying datasource.............sounds complicated, it is (maybe overly so). I guess if I could get Query to return a crosstab dataset, I would not need the pivottable although I do use the field variables in pivottable to change my period selection.
Paul