How do I use pivot table data for further calculations?

[Nisse]

Hi,

I have a query, which in PivotTable View presents information that I
would like to do some further calculations on. Is there a way to store
a query pivot table as a separate data table in the data base? Or is
it possible to, from another query, call on the result of a query in
pivot table view?

Regards

//Nils

 

[Nisse]

Hi,

I have a query, which in PivotTable View presents information that I
would like to do some further calculations on. Is there a way to store
a querypivottableas a separate datatablein the data base? Or is
it possible to, from another query, call on the result of a query inpivottableview?

Regards

//Nils

Nobody has any idea? I fail to progress here so I would be grateful
for any help

//Nils

 

[Just Muddling Through]

You might write a Crosstab query that emulates the results of the pivottable.
The results of the crosstab query can be inserted into a table for further
manipulations.