2 Replies Latest reply: May 27, 2010 3:35 AM by umangu2000 RSS

    rows other than selected

    Anil Konduri

      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