Limitations for Calculated Field formulas in Pivot Tables

B

Brandon_469

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
 
J

Jim Thomlinson

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.
 

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

Delete calculated field 1
Calculates field in pivot table 2
Pivot table, IF function, calculated item versus calculated field 1
Problem with Calculated item in Pivot Table 1
Formulas in Pivot Tables 2
Pivot Table calculated item 4
Pivot tables calculated fields 2
Pivot Table - Calculated Field - Percentage - Rept 2

Top