Limitations for Calculated Field formulas in Pivot Tables

  • Thread starter Thread starter Brandon_469
  • Start date Start date
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
 
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

Calculates field in pivot table 2
Problem inserting calculated pivot fields into Pivot Table (2007) 1
Delete calculated field 1
Pivot table formulas 1
how do I remove #DIV/0! in a pivot table calculation field ? 2
Pivot table, IF function, calculated item versus calculated field 1
Pivot Table - Calculated Field - Percentage - Rept 2
Problem with Calculated item in Pivot Table 1

Back
Top