Criteria for external data in a pivottable

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

Excel 2010

My pivottable is based om external data. The datasource is a view
showing data for multible sites and years.

Is it possible to set a filter so that I only receive e.g. data for
this year ?

Regards

Peter
 
I got it.

The answer is to change the Command Type and Command Text in the
Connection Proerties.

Regards

Peter
 
Back
Top