When I designed a pivot table this morning the left hand side of the screen had a box that said "PivotTable1" "To build a report choose fields from the PivotTable field list" and I built my table as usual. This afternoon when designing a pitvot table the left hand side of the screen says "Drop Page Fields Here", "Drop Column Fields Here" "Drow Row Fields Here" and "Drop Data Items Here". The resulting table does not let me filter as I would like. What happened???
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Pivot Table Problems - Excel 2009
- Thread starter ahtarski
- Start date
Excel Facts
Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Similar threads
- Question
- Replies
- 1
- Views
- 482
- Replies
- 0
- Views
- 735
- Replies
- 0
- Views
- 286
- Question
- Replies
- 2
- Views
- 1K
