Date Filter issue

  • Thread starter Thread starter Sri Harsha
  • Start date Start date
S

Sri Harsha

I have a pivot table which has Report Filter as date. I want to have a week
view (like Wk1, WK2 etc) in the filter. Is it possible? if yes, how?
 
In xl2003, you can group by dates by years, months, quarters, but not weeks.

I'd use a helper column and use a formula that returns the week number based on
the date field.

You may want to read Ron de Bruin's site for more week number info:
http://www.rondebruin.nl/weeknumber.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date filter in weeks. 1
Linking to a filtered (hidden) cells 2
Grouping COLUMNS. 2
Help in pivot 1
Refresh external data message 1
date filter in a pivot table 1
filtering dates in a Pivot Table Report Filter 3
XL2007: Pivot table date filter 1

Back
Top