Dynamic Sum to display only non-zero results

[mprocacc]

Hi,

I've been stalking boards like this for... decades. My first time posting. Thanks in advance.

I'm trying to develop a dynamic spill result that will display only non-zero results.

In the attached image I'd like to suppress the non-zero results so-as only Vendors with a non-zero value will be displayed. Seems simple but I cannot figure it out. My spill formula is:

=SORT(HSTACK(UNIQUE(MOAR[Manufacturer]),SUMIFS(MOAR[Display Amt],MOAR[Manufacturer],UNIQUE(MOAR[Manufacturer]),MOAR[Include?],TRUE)),1,1)

The results below are correct but I don't want to display the Vendors with zero dollars. I'd like to "collapse" those zero-dollar vendor rows.

Sorry .. again my first post

Thanks in advance.

Matt

My data table ("MOAR") has a helper column ("Include?") which considers several variables and, for each row in the table, is either TRUE or FALSE.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=let(s,SORT(HSTACK(UNIQUE(MOAR[Manufacturer]),SUMIFS(MOAR[Display Amt],MOAR[Manufacturer],UNIQUE(MOAR[Manufacturer]),MOAR[Include?],TRUE)),1,1),filter(s,index(s,,2)>0))

 

[mprocacc]

Wow.

Just...wow.

Thank you! I was trying to figure out how to FILTER a FILTER and could not for the life of me figure out how to reference the columns within the first FILTER.

I kiss your ring, Fluff

 

[Fluff]

You're welcome & thanks for the feedback.