Forum Discussion
Dynamic tables
- What would it mean the average of minutes as it seems not to have any sense in this case?
That's just sum of minutes for all records in the period divided on number of such records, I don't know what that's all about and does it have any sense from business logic point of view.
- If I want to know the total for every year, do I have to introduce a column in the data sheet for the year number?
Yes, just add one more grouping by years
Once again your help has been very useful for understanding pivot tables and taking advantage of my data sheet. Thank you very much indeed.
The only field that I still cannot understand and develop properly is the “average” funtion. I would like to know how to calculate averages of daily, weekly, monthly and year activities...
What would you suggest or recommend to understand and learn this area?
Hi Juan,
Average is calculated as sum of all values divided on count of all values under the level. If you have sub-levels, the average of the level is not the average of all sub-levels, it's the average of all items under it.
Let take this grouping for AAA
If you take Weekdays average it is not equal to average of values for 01-04 Jan (which is 34:46). They itslef are also averages for the each of the day.
If you take min for all AAA from 01 to 04 Jan in [mm]:ss format and take the average from it you'll have exactly the same what is in PivotTable for that level
Thank you again for your quick answer and clear example. Now I have understand the way it works!!
However what I am looking for, is the average of the each activity (AAA/BBB/CCC/DDD ) on the whole day, week, month or year.
Do you have an idea of how this could be calculated?
juan jimenez , perhaps I misunderstood something, but you already have minutes average in this column