5 Replies Latest reply: Jan 10, 2012 5:23 PM by silviu andries RSS

    Pivot table problem, reduce the X and Y axes depending on my selection...pls help

    silviu andries

      Hi all!

       

      I have searched and got no information for my problem...

       

      I have the following issue:

      I created a pivot table X-years from field 1 table A, Y-years from field 2 table B.

       

      YEAR2006200720082009201020112012

      2012

      50030038000600700-50
      2011-2025-14001400800
      2010-222---
      2009--800-
      20082565-2500
      20071122556
      20061000

       

      and a list box
       

      YEAR
      2012
      2011
      2010
      2009
      2008
      2007
      2006

       

      OK. What I would like to do is to make a connection between X axes-Yers and Y axes-Years so, after I select one year from my list box in my table to remain only the 6 years in the past depending on my selection.

       

      For example if i select YEAR 2012 my table must be smaller with 1 collumn for X and 1 for Y axes, and to display only the Years 2012,2011,2010,2009,2008,2007 on both axes,  with their values....in one word, to make the 2006 year dissapear...

       

      every information will be very usefull.

       

      Thak you,

      Silv.