Pivot Table Reports - avi- Average Max Min By Category

preview_player
Показать описание
Analyzing category results: adding more subtotals. Create a report that indicates which products are in which categories and how much of each product was sold in each of Qtr 1 and Qtr 2 as well as the total sales (i.e. Sum) and the Average, Max and Min of all sales during the quarter by Category.
Рекомендации по теме
Комментарии
Автор

Many thanks, how to get min and max for each column of table within each category?

igorfomenko
Автор

Will that work in 2016 excel as well....?

dr_jaidevkhatri