6 Replies Latest reply: Dec 2, 2014 2:58 PM by Ama Domevscek RSS

    Variable pivot table

             01-01-2014 - 01-11-2014         01-10-2013 01-12-2013

             number

      52  11                                                              23

      51  12                                                              22

      50   13                                                             20

      49    15                                                            18

       

      Hello I want to do next:

       

      First column 1 weeknrs,

      column 2 number sells in period 01-01-2014 - 01-11-2014

      column 3 number sells in period 01-10-2013 01-12-2013

       

      The Period is variable.

      How can i do this the best?

       

      Create 4 input boxes, from which the user can select a date from a calender?

      How can i show variables in the top?

      Please advice to realize.