Is it possible to drill down on calculated items in a pivot table? On non-calculated items, I can drill down just fine--by double-clicking the item, it creates a new sheet with full details. However, when I double click on a calculated item, Excel just displays the formula that comprises that item. What am I doing wrong or is this just a limitation of calculated items?
-
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.
Drilling down in a calculated item in a pivot table
- Thread starter paydog23
- Start date
Excel Facts
Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Similar threads
- Replies
- 0
- Views
- 444
- Question
- Replies
- 0
- Views
- 62
- Replies
- 0
- Views
- 186
- Question
- Replies
- 0
- Views
- 222
- Solved
- Replies
- 11
- Views
- 226
