date as dimension and show only last 7 days

[#1]

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

[dkmanley]

this worked great but i changed it to -31 days. 

Now I want to only show weekdays Monday - Friday). How would i modify this expression? 

=if(SessionsRefreshDate >= today()-31 and SessionsRefreshDate <= today(),SessionsRefreshDate)

in the main section the first weekday is set as 

SET FirstWeekDay=6;