8 Replies Latest reply: Aug 9, 2016 2:06 PM by Stefan Wühl RSS

    date as dimension and show only last 7 days

    Cosmin Cirnu

      hi all,

      i have a pivot table with names on rows and dates on columns and i want to see only last 7 days (in this dimension i have current month, last month and current month from last year - day by day)

      and calculated expression like sum (sales) for eg

       

       

       

                 1 sep 2012 .....30 sep 2012    1 aug 2013..31 aug 2013  1..4 sep 2013

      john

      paul

      alma

       

      so what i want is:

               29aug2013  30aug 2013  31aug 2013  1sep 2013    2sep 2013  3sep 2013 4 sep 2013

      john

      paul

      alma

       

      date format is 9/4/2013

       

      thanks