How to filter a field in pivot table using two filters

I am trying to filter a Total_Effect field in a pivot table based on two filters. The first filter is for value less than 0% and this result is then filtered to give me the bottom five results. The following shows how the source data could look like (note I have simplified the source data for this example). In the first example, it should give me the value of -0.20%, -0.80% & -1.00% and the second example should produce value of -0.15%, -0.20%, -0.40%, -0.80% & -1.00%.

Stock Total_Effect
A 0.30%
B -0.20%
C -1.00%
D -0.80%
E 1.10%

Stock Total_Effect
A 0.30%
B -0.20%
C -1.00%
D -0.80%
E 1.10%
F -0.40%
G -0.15%


I know the vba code for filtering value less than 0 (shown below in bold) but don't know how to add another filter on the result of the first filter.

Please Login or Register  to view this content.

Thanks in advance

post withdrawn by hum

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I have added them for you - this time

someone can correct me if im wrong but im pretty sure you cannot apply two value filter per pivot field
ie filter on top of filter

the only way i can think of doing both bottom 5 less than zero you are going to need to do it with array and pivotitems filter
much in the same way you would do for autofilter

i knew that was the coming question
in all honestly i dont think i have done the best job of it...it seems to be a mish-mash of things as i am not very well versed in arrays
and pivot vba is a minefield to me

anyway since you didnt provide any data to work with...i just made it up to what i think your WB looks like