Select Green/ Red from list box respective change in the pivot table

[#1]

Hi,

any one help me in solving the problem

application is attach in the attach file,

i need only

when i click on the list box (exp: Red ) , Only Red Image in the pivot table is shown along data

any suggestion please..........

thanks

[#2]

You can create a macro and let it run on the field selection (green or red).

In the macro you should ser a funcrtion that if the selection is red for the positive velues must be hidden and on green selection the negative must be hidden.It's simply