PIVOTBY / GROUPBY filtering

[pholt33]

I have a PIVOTBY that works but I want to filter out some of the data and am running into an issue. Here is what I have...

=PIVOTBY(Table4[SlicerDate],HSTACK(Table4[Tags],Table4[Group]),Table4[Amount],SUM,0,0,,2,,Table4[Group]<>"Transfer")

How can I have 2 criteria in the filter_array? I want Table4[Group]<>"Transfer" and Table4[Tags]<>"Split"

 

[Peter_SSs]

I want Table4[Group]<>"Transfer" and Table4[Tags]<>"Split"

Is this what you mean?

=PIVOTBY(Table4[SlicerDate],HSTACK(Table4[Tags],Table4[Group]),Table4[Amount],SUM,0,0,,2,,(Table4[Group]<>"Transfer")*(Table4[Tags]<>"Split"))

 

[pholt33]

I thought I had tried that method but obviously did it incorrectly. I copy/pasted yours and it worked perfectly. Thanks!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.