My question is exactly the same as this one, but, for some reason I don't get, the answer doesn't work (or I don't read it right). Maybe something changed since then.
Let's say I have this. I get a count for of eventid for each user by day:
Now, I want the grand total column to show the average for each row, so the average daily count by user. But for each day, I do want the count for the user.
So, I right-click anywhere in the Grand Total column, the Summarize Values By > Average. And this is what I get:
Instead of updating the calculation for the Grand Total column, it did for the entire set of values.
What am I doing wrong?
Thanks!
