Pivot table, display weeks

Tshurlock

New Member
Joined
Jun 28, 2018
Messages
7
Hi,
I have created a pivot table that is displaying expenditure by year, quarter and finally month. Is there any way I can get it also diplay break done for each week in a month?
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

BGY23

Well-known Member
Joined
Aug 13, 2008
Messages
515
Hi,
Yes if the week is in the source data. If it isn't can you add it based on a date ?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,525
Messages
5,523,377
Members
409,514
Latest member
MarkZuckerberg

This Week's Hot Topics

Top