Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table
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 "scrabtree23" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Pivot Table and Pivot Table dates are not in correct order | Charts and Charting in Excel | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming |