I want to calculate the Avg/Min/Max no of Products for the Category/Sub-category in the below attached work sheet.
Thanks in advance for the help.
Do you want something like this?
Attaching 9.1.0 workbook
I want to see the AVG/Min/Max of the Count Distinct for Sub-Category and Product Name. not for the Quantities, I mean Avg/Min of CNTD(Dimensions).
Retrieving data ...