Dear experts i am trying to add a button, which should be connected to my pivot table. There will be 3 buttons. The buttons will filter the pivot table to show positive values, all values and only negative values. Thank you experts

[Anonymous]

Header 1	Header 2	Header 3	Header 4
oximorphone	23	12	11
Adrophone	14	40	-26

This is a example of how the pivot looks like.

Negative Values button =  will show only line Adrophone

Positive Values button = will show only line oximorphone

And All values will show the entire pivot table

Thank you experts.

[vishsaggi · Accepted solution]

Check this attached.

[Anonymous]

works like a charm boss.

Thank you

[vishsaggi]

Glad it worked for you. No problem.