| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limitations for Calculated Field formulas in Pivot Tables
Is there a list or even a guideline on what excel formulas are allowed when
creating a Calculated Field in Pivot Tables? For example, I want to use the TODAY() function in the pivot table, but I keep receiving errors. Is there a way to use a function that operates like the TODAY or NOW functions within the Calculated Fields? Thanks, Brandon |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Limitations for Calculated Field formulas in Pivot Tables
Volatile functions are not allowed. The power of pivot tables and cubes in
general is that they pre-aggregate the values so that when you request the data it does not need to perform any mathematical functions. Since volatile functions are constantly changing they are not allowed. -- HTH... Jim Thomlinson "Brandon_469" wrote: Is there a list or even a guideline on what excel formulas are allowed when creating a Calculated Field in Pivot Tables? For example, I want to use the TODAY() function in the pivot table, but I keep receiving errors. Is there a way to use a function that operates like the TODAY or NOW functions within the Calculated Fields? Thanks, Brandon |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculated field in pivot tables | Excel Discussion (Misc queries) | |||
| pivot tables - insert calculated field | Charts and Charting in Excel | |||
| pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
| Calculated field in Pivot Tables | Excel Discussion (Misc queries) | |||
| Pivot Tables - How do I add Functions as a Calculated Field? | Excel Discussion (Misc queries) | |||
Linear Mode
