Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to use pivot data in formula or fuctions?
Hi,
I've extracted out some data using pivot, and have results as shown below example # country A B C 1 USA 1 0 3 2 JPN 0 0 1 Next I'd like to get the max value of column A, B and C and so I make use of the function =max(A1,B1,C1) (note : the values are captured by selecting the cells which A1, B1 and C1 will be captured. But when I drag to the 2nd Row, to copy the formula/fucntion to the next row, the formula still capture A1,B1,C1 instead of A2,B2,C2 Any idea how to by pass this instead of copy the results into another column as static info bec I am trying to automate and avoid using static way of doing things. -- summerhayashi |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to use pivot data in formula or fuctions?
Pivot table calculations should be done with the pivot table formula wizard
(PivotTable Tools, Options, Formulas, Calculated Field). Name the new field, In the Formula: =max('yourfieldA','yourfieldB','yourfieldC') or in your example =max('A','B','C'). The formula will copy it's self down. Also as the pivot table grows & shrinks, so will your formula cells. -- Kevin "summerhayashi" wrote: Hi, I've extracted out some data using pivot, and have results as shown below example # country A B C 1 USA 1 0 3 2 JPN 0 0 1 Next I'd like to get the max value of column A, B and C and so I make use of the function =max(A1,B1,C1) (note : the values are captured by selecting the cells which A1, B1 and C1 will be captured. But when I drag to the 2nd Row, to copy the formula/fucntion to the next row, the formula still capture A1,B1,C1 instead of A2,B2,C2 Any idea how to by pass this instead of copy the results into another column as static info bec I am trying to automate and avoid using static way of doing things. -- summerhayashi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
About Fuctions | Excel Worksheet Functions | |||
Creating Nested If Fuctions | Excel Worksheet Functions | |||
Using Worksheet Fuctions with Macros | Excel Discussion (Misc queries) | |||
Equalls fuctions | Excel Worksheet Functions | |||
unrecognized fuctions evapp etc | Excel Worksheet Functions |