Pivot table - average value problem

[johanfo2]

Hi,

I have an annoying problem with calculating average values in pivot

I have a 2 dimensional pivot table,  horizontally is the Dates, and vertically is the Names

Now, the expression is "count(ID)"  which lists then, for each name and date, how many "IDs" there are.  So far so good.

Now, I have tried to replace the "count(ID)" with an expression which should compare the number of IDs with the average across time, but per name.

So, rephrase,  per "name", the expression should be count(ID) / { average(count(id)) across all dates, but not across all name}

I have tried to do something like this: =avg(aggr(count(ID), Dates))  but it seems to fail.

Any suggestions?

[#2]

try presentation tab and show partial sum

[swuehl · Accepted solution]

Try

=count(ID) /  avg(total<Names> aggr( count(id), Names, Dates))

[johanfo2]

Outstanding!  In fact, I did try something similar based on reading the documentation.  Howver, I misinterpreted the "anglebrackets" to be "[" or "{", thus it failed.

Thanks a lot.