Pivot Table counting comma separated values filtered by Date

[Grumbledore]

Hello,

I am writing this post as a follow up to this thread: pivot table from columns with strings separated by commas

I would like to count the unique comma separated values in Table1[Column1] or A2:A4, which can be done by a formula posted at the link above, but I am also hoping to have this data work when Table1 is filtered by date, similar to the manner in which SUBTOTAL works.

Is this possible without VBA? Security at my work facility doesn't allow macro enabled workbooks.

 

[Fluff]

How about

=LET(d,FILTER(Table1[Column1],MAP(Table1[Column1],LAMBDA(m,SUBTOTAL(103,m)))),e,DROP(REDUCE("",d,LAMBDA(x,y,VSTACK(x,TRIM(TEXTSPLIT(y,,","))))),1),u,UNIQUE(e),HSTACK(u,MAP(u,LAMBDA(m,SUM(--(e=m))))))

 

[Grumbledore]

How about

=LET(d,FILTER(Table1[Column1],MAP(Table1[Column1],LAMBDA(m,SUBTOTAL(103,m)))),e,DROP(REDUCE("",d,LAMBDA(x,y,VSTACK(x,TRIM(TEXTSPLIT(y,,","))))),1),u,UNIQUE(e),HSTACK(u,MAP(u,LAMBDA(m,SUM(--(e=m))))))

Fluff you are a beautiful person and I hope you feel valuable and appreciated wherever you are.


Problem solved.

 

[Fluff]

You're welcome & thanks for the feedback.