Hi,
I have a simple query that returns retailer name, month, and a value figure. I have plotted retailer name as series, month as X axis, and the value figure as data.
There are multiple entries with the same retailer name and month because there are lots of branches.
The only aggregate option available in the Autocalc menu is 'count' - all the other are greyed out.
How do I get the average instead of the count?
Thanks!
I have a simple query that returns retailer name, month, and a value figure. I have plotted retailer name as series, month as X axis, and the value figure as data.
There are multiple entries with the same retailer name and month because there are lots of branches.
The only aggregate option available in the Autocalc menu is 'count' - all the other are greyed out.
How do I get the average instead of the count?
Thanks!
