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

Slicers and Calculated Items in Pivot Table 2
Dealing with a Pivot Table (when I don't want to) 0
Sorting Multiple Tables 1
Delete calculated field 1
Creating a Calculated Field in a Pivot Table for same field 3
Calculates field in pivot table 2
Formula within Pivot Table Calculated Field - Days in time period 0
Calculated column label in pivot table? 0

Top