Pivot table help

[MJJ987]

My source data is showing in daily buckets but when I create a pivot table it changes to monthly, ultimitly I would like to see it in weekly buckets, can anyone help?

[#2]

@MJJ987 

Right click on it, Grouping, here select only Days and Number of days = 7, adjust Start and End if necessary

Result will be like

[#3]

@MJJ987 

Second screenshot disappeared:

[#4]

@MJJ987 

Alternatively you may add week # column directly to the source; or creating Pivot Table add data to data model and add in it; pivot on week #

You may add as well Year, Month, Date (whatever)  to hierarchy if necessary.