Hi guys

im working with this data below and its from January to December:

DATE REF DESCRIPTION SALES DEPOSITS BALANCE
03-01-14 4000 vendas 1829 kgs sem.1 274350 274350
03-01-14 4001 vendas 250 kgs sem.1 98000 372350
03-01-14 4002 bta td.88190544 143100 229250
03-01-14 4003 bta td.88190544 137700 91550
10-01-14 4005 vendas 972 kgs sem.2 145800 237350
10-01-14 4006 vendas 45 kgs sem.2 10800 24150
10-01-14 4007 vendas 1300 kgs sem.2 743600 991750
10-01-14 4008 vendas 9073 kgs sem.2 1353450 2345200
10-01-14 4009 vendas 700 kgs de sapatos sem.2 400400 2745600
10-01-14 4010 bta td.88244608 98000 2647600
10-01-14 4011 bta td.88244780 4300 2643300
10-01-14 4012 bta td.88248268 73350 2569950
10-01-14 4013 bta td.8825609 72450 2497500
10-01-14 4014 bta td.88427813 192000 2305500
10-01-14 4015 bta td.88426336 76800 2228700
10-01-14 4016 bfa cs td.88428876 213000 2015700
10-01-14 4017 bta td.88426993 373200 1642500

I need to sort it in a pivot table so that it shows:


1. Date Description Sales and deposits
2. Then i need to sort these sales and deposits into weeks, so that i have 52 weeks sales than daily sales.

Help

Viola