Table Chart > Show Totals > Show Avg > Show Max > etc....
Allow the "summary" row to show EITHER Totals, Or Average, Or MAX, OR etc....
Take a look at any Excel pivot table to see how this functionality is implemented
2
votes
Jerry
shared this idea