Adding a formula to a pivot table

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Hi,

I have constructed a pivot table that summarises data from
11,000 rows. It works well enough but I have been asked
to produce totals of certain data. There are 28 Companies
in my 'Data' table, which contain applications for
projects. Applications occur more than once but always
belong to the same company.

I can produce a pivot table to show applications by
Company but how do I produce a pivot to count how many
times a unique application occurs by Company. The best
that I could achieve was to add a formula in the top
row '=COUNTIF(B2:B10000,"*")', filter the company in the
page field to produce total unique applications by
company.

Can I add a formula to my pivot table to automate this
process. It would be very handy and would save me loads
of work.

Regards

Tony
 
You must log in or register to reply here.

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

Referencing a pivot tables Grand Totals Column 1
Adding to an existing Pivot Table 7
Pivot tables - adding dates, descriptions 1
Pivot table filter list - listing irrelevant subcategorys 1
How to Clear a Pivot Table Cache 1
I think I need a Pivot Table ,but not sure.... 2
A Pivot Table challenge--I can't do it, can you? 5
Problem with pivot tables overlapping with new data 1

Back
Top