rows other than selected

[#1]

Hi All,

I have two pivot charts

chart 1:

Country, Region, Specific, Name, price, rate, ...........

I am filtering the chart by Country, specific, region, name

Chart 2: (Same columns as chart1)

Country, Region, Specific, Name, price, rate, ...........

But I want my 2nd chart should populate rows below the rate selected / filtered for first chart as suggested rate.(excluding selected rows in chart 1 and the rate >= selected rows rate)

Thanks in advance

[#2]

Please Help.... its urgent

[#3]

you need to explain your problem in a better manner, perhaps upload some document and ask specific quesations and the community might be able to help you