Criteria for external data in a pivottable

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
 
P

Peter

I got it.

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

Regards

Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a Pivottable with text only data 1
Placing a Pivottable in A1 0
Excel 2010 PivotTable Oddity 2
Totals in pivottable 0
import external data as a List (not table) into excel 2010 with excel 2000-2003 list format 0
lookup from a table in a pivottable 4
The Number Format button missing in Pivottable 0
Multiple criterias in a Pivot filter 1

Top