formula needed to extract only those values not hidden by filter

[tbablue]

Hi forum,

I have a table with table slicers.

Is there any way (by use of formula) to extract only those values in a prescribed field that are visible after slicers are employed? I want to capture these in a different sheet.

I use this formula to sum the associated values from Planning[Wk#1]- but I want a detailing of the actual items from Planning[Demand] also.

=SUMPRODUCT((Planning[[Demand]:[Demand]]=1)*(SUBTOTAL(9,OFFSET(AE32,ROW(Planning[Wk'#1])-MIN(ROW(Planning[Wk'#1])),0))))

Any assistance most gratefully rec'd.

Thx in advance

 

[tbablue]

Did you put the subtotal formula into the IsVisible column?

Thanks for sticking with me, Fluffy. Really appreciated. Problem solved.
I'll mark accordingly.

 

[Fluff]

Glad we could help & thanks for the feedback.