Microsoft Office Tutorials and References
In Depth Information
Using AGGREGATE to Ignore Error Cells or Filtered Rows
the AGGREGATE function in D3. The advantage of AGGREGATE is that it can
return MEDIAN, LARGE, SMALL, PERCENTILE, and QUARTILE on the visible
rows as well.
Figure 11.5.
Figure 11.5. AGGREGATE
AGGREGATE performs calculations on the visible items of a
performs calculations on the visible items of a
filtered data set.
filtered data set.
Search JabSto ::




Custom Search