How do I use pivot table data for further calculations?

  • Thread starter Thread starter Nisse
  • Start date Start date
N

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
 
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
Click to expand...

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

//Nils
 
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.
 
Back
Top