Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables - Calculated Item
Hi
I have a calculated item formula which uses the sum function. It selects certain columns to sum up. The problem I have is that these categories I need to sum up change each day, which means I have to manually select the columns to add up - which is time consuming. How could I get around this problem? Thanks W |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables - Calculated Item
Have you looked at the GetPivotData function? You can replace some of the
hard coded values with something like "A1" where A1 contains the value you need. -- HTH, Barb Reinhardt " wrote: Hi I have a calculated item formula which uses the sum function. It selects certain columns to sum up. The problem I have is that these categories I need to sum up change each day, which means I have to manually select the columns to add up - which is time consuming. How could I get around this problem? Thanks W |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
Calculated Field/Item in a Pivot | Excel Worksheet Functions | |||
calculated field/item in pivot tables | Excel Discussion (Misc queries) |