Hello,
My data is as follows
username | date created
a | 04/03/2009 15:34:58
b | 12/03/2009 10:51
c | 20/03/2009 20:39
d | 04/03/2009 15:34
not sorted by date created. I am after a chart that shows the cumulative number of new users per week. Using 2007 so used the weeknum function giving me the number of new users per week. I pull this in a pivot table, so I get a count of users per week I can show in a line graph. So far so good. Now I need to display the cumulative number (so, total of users over time)... grateful for your help.
Last edited by deemo; 06-04-2009 at 11:57 AM.
Found the solution... must have been asleep. Changed pivot field to count, show value as running total. Done!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks