nicolaskruchten / pivottable

Open-source Javascript Pivot Table (aka Pivot Grid, Pivot Chart, Cross-Tab) implementation with drag'n'drop.
https://pivottable.js.org/
MIT License
4.35k stars 1.08k forks source link

Adding average to bottom just above Total for each column. #1258

Open Yodavish opened 3 years ago

Yodavish commented 3 years ago

Hello I've been reading the wiki, more specifically the aggregators section, but so far, unable to find a way to add an "Average" row along with having the "Totals" row. The average would be total count and divided by number of active hours per row.

image

In this case, we have a total of 48 counts, but only 3 active hours. Average would be "Total Count/ 3" = 16.

Is there an example of something like this?