Displaying Pivot Table Results

P

Popey

Hi

Using Excel 2007:

I have a pivot table that produces results from a list of clients entered
into a database each time a client uses my services. The pivot table
displays the clients name and amount of times they have used the service.
What I would like to know is this;

How can I get the bar-chart, which I use as a quick-look reference tool of
my clients, to only show those clients who have used my services two times or
more?

Very many thanks.
 
B

Bam

Popeye,

If you always want to base your chart on the same pivot table the the pivot
table will need to change with each view you need.

How many fields are being used in the pivot table?

Could you create a claculated field? = count(customer)

Bam.
 

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

Top