Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am brand new to pivot tables. I just created one and it looks like it has
all kinds of potential. I dropped a couple columns in the data field in the
wizard. Then under field settings it lets me pick sum or count etc. I want
a custome formula here. Like a SumIf tied to a value in another cell some
place else.
 
Hi scrabtree

you can add multiple fields into the column & row sections and filter for
the items (by clicking on the drop down arrows) you want to see - this
generally gives the same benefits as the sumif type criteria - the page
field can be used to give an overall filter.

does this help at all or do you need to use other formulas (btw, calculated
fields can be entered by choosing pivot table / formulas / calculated fields
from the pivot table toolbar)

Cheers
JulieD
 
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

Unable to Group in Pivot Table 1
Pivot table multiple filters 2
Using VBA on Excel Pivot Tables 3
Excel 2010 Pivot Table 2
Help list box to update pivot table 1
Link Drop Down list with Pivot Table 3
Playing back a Pivot Table macros 2
Pivot Table Question 2

Back
Top