When using a pivot table you can highlight rows or column data and group
them. If the pivot table is updated and there is new data that fits a
particular criteria, it would be useful if the grouping would automatically
add them in. I know this could be done by creating a group field in the data
source, or by macro, but sometimes this is impractical.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.
www.microsoft.com/office/comm...lic.excel.misc
- Mar 13 Thu 2008 20:43
Pivot table, grouping by formula
close
全站熱搜
留言列表
發表留言