Dynamic arrays

[mobeen2340]

How I can get customer revenue value by using dynamic arrays in dependent drop down list. Please see workbook and help me 

[#2 · Accepted solution]

@mobeen2340 

Formula here

is

=SUMIFS(Table3[Revenue], Table3[Customer Name],$G$7, Table3[Sub-Category], $F$8#)

[#3]

Thank you. Problem is solved.

[#4]

@mobeen2340 , you are welcome