Calculated formulas in pivot tables

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hi everyone,

I have a list of data that includes the following

User, Login Date, Creation Date, Today's Date, Days since = (Today -
Creation date)

Each user has a login date and I'm counting the number of logins to see how
many times they log in per days on average. I therefore use today's date
against their creation date to see how many days they have been an active
user and then divide their nb of logins by active days.

The problem is that as the Days since column in my list is repeated several
times for each login date, I therefore use Average of Days Since in the
pivot table to display just once the number. I am therefore unable to run
the calculation properly.

Does anyone know how to run a calculation using the value that is displayed
in the pivot table?

Thanks very much for any help you can give me,

James
 
Would it help if you had the "days since" field appear only once per user in
your table?

If yes, then maybe you could use a formula like:

=if(countif($a$2:$a2,a2)=1,today()-c2,"")

(User in column A, Creation date in C and I used =today() instead of the date in
column D.)
 
fantastic, thanks Dave, this works perfectly.


Dave Peterson said:
Would it help if you had the "days since" field appear only once per user in
your table?

If yes, then maybe you could use a formula like:

=if(countif($a$2:$a2,a2)=1,today()-c2,"")

(User in column A, Creation date in C and I used =today() instead of the date in
column D.)
Click to expand...
 
Back
Top