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
 
Ad

Advertisements

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
Problem inserting calculated pivot fields into Pivot Table (2007) 1
Calculates field in pivot table 2
how do I remove #DIV/0! in a pivot table calculation field ? 2
Pivot table formulas 1
Pivot Table criteria 2
Problem with Calculated item in Pivot Table 1
Pivot Table - Calculated Field - Percentage - Rept 2

Top