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



Sri Harsha wrote:

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?

--

Dave Peterson