Calculated Fields Functions

[Ruugatti]

Hi I have been searching online and unable to find an answer I am looking for. I am trying to create a calculated field in a pivot table using the NETWORKDAYS function as part of the calculation however I am unable to create it with success. My question is: are there only certain functions available to be used in the calculated field.. or do all functions work and the problem is syntax error on my end? Thanks.

 

[cerfani]

i believe you are limited to these types of calcs... someone can correct me if i am wrong

https://msdn.microsoft.com/en-us/library/office/ff837374.aspx

so if it isnt there then construct the table yourself manually and dont use a pivot. You can make your own pivot table.