Jun 06 2020 03:50 AM
How I can get customer revenue value by using dynamic arrays in dependent drop down list. Please see workbook and help me
Jun 06 2020 03:59 AM
SolutionFormula here
is
=SUMIFS(Table3[Revenue], Table3[Customer Name],$G$7, Table3[Sub-Category], $F$8#)
Jun 06 2020 03:59 AM
SolutionFormula here
is
=SUMIFS(Table3[Revenue], Table3[Customer Name],$G$7, Table3[Sub-Category], $F$8#)