convert excel formula to excel pivot table formula

[monnet]

Hi everyone,

I have a excel spreadsheet that contains information on website "hits" (and other various statistics)I created a forumula that shows the hits per business day.

Formula is as follows: 'Hits'/(networkdays(Today(),'Website Start date')

How can a translate that formula into an Pivot table- Error message reads:
"Your formula includes a function that cannot be used in PivotTable formulas. You cannot use functions that return variable results, such as rand and now, database functions, or the getpivotdata function in Pivottable formulas."

Thanks for any help in advanced.

Brad

 

[SkipVought]

Why no have a column in your source data for your networkdays function result?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[monnet]

good idea i think that will work.... Thnks